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 ONE Support launchpad (Login required).

Search for additional results

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