SAP Knowledge Base Article - Preview

2589639 - How does Load work in IQ -- SAP IQ

Symptom

How loading process works internally

Details on load (pass 1 and pass 2 )

 A load process consists of the following steps:

   a)  read data from file
   b)  convert data from ascii to binary format
   c)  assign rowid to each row of data
   d)  insert data into index
   e)  performing referential integrity checks
   f)   evaluating table and column check constraints

The logic exercised in step (d) varies from index to index.

   -  For  FP(NBit), DATE, DTTM, and TIME indexes, data is inserted directly into the index.
   -  For HG and WD indexes, data is sorted prior to inserting the data into the index. 
   -  Steps (e) and (f) are performed as required.

The above steps are exercised as follows relative to pass 1 and pass 2

  Pass 1
 ======

   steps (a), (b), (c)
   step  (d)  - for  FP(NBit),  DATE, DTTM, and TIME indexes, data inserted into the index
                  - for HG and WD, data put into a sort

  Pass 2
 ======

   step (d)  - for HG and WD indexes, data is retrieved from the sort and inserted into the index
   step (e)  - perform referential integrity checks
   step (f) is performed after Pass 2 is completely finished.

IQ Large memoy (or Virtual memory) is used to store both the data manipulated in step (a) and step (b).  
The amount of virtual memory can be controlled using the "-iqlm" start-up parameter option.  
The sorting done for HG and WD indexes uses IQ temp cache.

Different thread pools are used for Pass 1 and Pass 2. The load process ideally assigns one thread to every IQ index.


Read more...

Environment

SAP IQ15.4
SAP IQ16.x

Product

SAP IQ 16.0

Keywords

"Load process" ; "Bulk load" ; , 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.