SAP Knowledge Base Article - Preview

1945786 - What happens in Pass 1 and Pass 2 of Insert /Load Table - SAP IQ

Symptom

An Insert or Load Table command can spend significantly more time in Pass 2 compared to Pass 1. What are Pass 1 and Pass 2 doing?

I.. 0000119536 Txn 812514036 0 812514036
I.. 0000119536 [20819]:
I.. 0000119536 Insert Started.
I.. 0000119536 Orders_Q4
I.. 0000119536 [20897]:  100000 Rows, 0 Seconds
I.. 0000119536 [20897]:  200000 Rows, 1 Seconds
...
I.. 0000119536 [20897]:  136400000 Rows, 1 Seconds
I.. 0000119536 [20897]:  136500000 Rows, 0 Seconds
I.. 0000119536 [20895]: Insert Pass 1 completed in 634 seconds.
I.. 0000119536 [20895]: Insert Pass 2 completed in 3413 seconds.
I.. 0000119536 [20834]:
I.. 0000119536 [20896]: Insert for 'Orders_Q4' completed in 4047 seconds.  136542018 rows inserted.
I.. 0000119536 Cmt 812535914
I.. 0000119536 PostCmt 0


Read more...

Environment

  • SAP IQ 12.7
  • SAP IQ 15.x

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

input data, indexes, sort, FP, LF, HNG, CMP, DATE, DTTM , 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.