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 for Me (Login required).

Search for additional results

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