SAP Knowledge Base Article - Preview

2210817 - Multi-thread loading may cause unorderable rowid

Symptom

  • When IQ uses multi threads on LOAD TABLE, rowids of imported data may be discontinuous. Below is the result of ' SELECT *, rowid(test) RI from test ORDER BY RI asc' after LOAD TABLE, the last column shows rowids. Rowid jumps from 13892 to 67108865.

    '1' '4276558271' '2015-08-09' 'A.E.49'               1700    201508  '1073'               13891 
    '1' '4101800464' '2015-08-09'                             490    201508  '0192'    '3162'  13892 
    '9' '4943674221646' '2015-08-08' 'WPCR-16887' 2457   201510  'NONE'   'NONE' 67108865 
    '9' '4943674221783' '2015-08-08' 'WPCR-16889' 2200   201510  'NONE'   'NONE' 67108866 
    '9' '4943674217649' '2015-08-08' 'WPCS-13241' 2600   201510  'NONE'   'NONE' 67108867 
  •  And there is possibility that rowids of imported data may not match the row order in original data file. Below is the result of ' SELECT *, rowid(test) RI from test ORDER BY RI asc' after LOAD TABLE, the last column shows rowids.

    '9' '4988001777847' '2015-08-08' 'COCB-54176' 2800   201507  'NONE'   'NONE' 3969 
    '9' '4988001778356' '2015-08-08' 'COCB-54179' 3000   201507  'NONE'   'NONE' 3970 
    '9' '4988001777977' '2015-08-08' 'COCP-39180' 2200   201507  'NONE'   'NONE' 3971 
    '9' '4988001777984' '2015-08-08' 'COCP-39181' 2200   201507  'NONE'   'NONE' 3972 
    '9' '4988001778011' '2015-08-08' 'COCP-39182' 3241   201507  'NONE'   'NONE' 3973 
    '9' '4988001778028' '2015-08-08' 'COCP-39184' 3241   201507  'NONE'   'NONE' 3974 

    The original row order in data file, from row 3969 to row 3974, which are completely different from imported data.

    9~4988002316014~20150808~VICL-8129~0002718~199506~NONE~NONE           3969
    9~4988002387809~20150808~VICL-41072~0002400~199908~NONE~NONE         3970
    9~4988002388196~20150808~VICL-41085~0002200~199908~NONE~NONE         3971
    9~4988002353408~20150808~VICL-60049~0001900~199706~NONE~NONE         3972
    9~4988002354603~20150808~VICL-60072~0002900~199709~NONE~NONE         3973
    9~4988002369720~20150808~VICL-60253~0002900~199807~NONE~NONE         3974

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

load table, rowid, thread, query plan, order , 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.