Symptom
- After the initail rebuild HG and FP indexes.
- The load went successfully.
- However, there is a performance issue, when running the load job.
- The iqmsg file show slowness during commit.
- It takes 10 mins for Cmt 9933805317. The sql is inserting to 'mytable' from the temp #mytable'
I. 10/02 09:48:16. 0000039087 Txn 9933803636 0 9933803636
I. 10/02 09:48:16. 0000039087 [20897]: 100000 Rows, 0 Seconds
I. 10/02 09:48:16. 0000039087 [20896]: Insert for '#bms_stats' completed in 0 seconds. 191593 rows inserted. ------>Insert and commit to temp table is immediate
I. 10/02 09:48:24. 0000039087 Cmt 9933803638
I. 10/02 09:48:24. 0000039087 TINFO t=9933803636 v=9933803636 c=9933803638 gt=0 gc=0 pcv=0 ME=0 MSE=0 TRR=0 #=0
I. 10/02 09:48:26. 0000039087 Txn 9933803649 0 9933803649
I. 10/02 09:48:27. 0000039087 Cmt 9933803665
I. 10/02 09:48:27. 0000039087 TINFO t=9933803649 v=9933803649 c=9933803665 gt=0 gc=0 pcv=0 ME=0 MSE=0 TRR=0 #=0
I. 10/02 09:48:28. 0000039087 Txn 9933803668 0 9933803668
I. 10/02 09:48:28. 0000039087 Cmt 9933803684
I. 10/02 09:48:28. 0000039087 TINFO t=9933803668 v=9933803668 c=9933803684 gt=0 gc=0 pcv=0 ME=0 MSE=0 TRR=0 #=0
I. 10/02 09:48:28. 0000039087 Txn 9933803687 0 9933803687
I. 10/02 09:48:34. 0000039087 [20897]: 100000 Rows, 4 Seconds
I. 10/02 09:49:00. 0000039087 [20896]: Insert for 'mytable' completed in 30 seconds. 191593 rows inserted.
I. 10/02 09:49:00. 0000039087 Generating HTML Query plan: /dir/sybase16/IQ-16_0/mydir/mytable_insert.html --->insert takes 30secs, however the commit post insert takes 10mins
I. 10/02 10:01:45. 0000039087 Cmt 9933805317
- What could cause the performance hit?
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
Keywords
CACHE_PARTITIONS, -iqpartition , , 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.