SAP Knowledge Base Article - Preview

2988195 - Load into table is running slow with long commit time in iqmsg - SAP IQ

Symptom

  • The load table command running slow with long commit time.
    For example:

I. 10/01 06:21:19. 0000043827 [20896]: Insert for 'tab1' completed in 13 seconds. 134448 rows inserted.
I. 10/01 06:27:20. 0000043827 Cmt 9933441202 ---> took 6 mins to commit

I. 10/02 09:49:00. 0000039087 [20896]: Insert for 'tab3' completed in 30 seconds. 191593 rows inserted.
I. 10/02 10:01:45. 0000039087 Cmt 9933805317 ---> took 12 mins to commit

  • Proactive DBA is calling sp_iqfile repeatly. 

  • In the pstack output, the following stack maybe seen :

#0 0x0000003d1ca0e334 in __lll_lock_wait () from /lib64/libpthread.so.0
#1 0x0000003d1ca095d8 in _L_lock_854 () from /lib64/libpthread.so.0
#2 0x0000003d1ca094a7 in pthread_mutex_lock () from /lib64/libpthread.so.0
#3 0x00007ff4781d6b45 in s_bufman::GetBuffersInUse() const () from /usr/local/sybase16/IQ-16_0/bin64/../lib64/libiq16.so
#4 0x00007ff478d47abe in db_StatusCursor::db_StatusCursor() () from /usr/local/sybase16/IQ-16_0/bin64/../lib64/libiq16.so
#5 0x00007ff478d4d010 in db_iqutilityOpenCursor::Parse() () from /usr/local/sybase16/IQ-16_0/bin64/../lib64/libiq16.so


Read more...

Environment

SAP IQ 16.0 SP11

Product

SAP IQ 16.0

Keywords

 CR 823026, CR823026 , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.