IBM Support

IT35964: REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • This problem should only affect load remote fetch (load from
    cursor, where cursor has a DATABASE clause), and only if source
    table has at least one LOB column.  It is data dependent and
    should be rare to hit.  The signature for the issue is the
    following entry in db2diag.log with SQLU_PRG_ERR from
    sqluCCrossParser::zParseColumn, probe:3678  (probe number may be
    slightly different):
    
    2017-07-04-12.11.12.878554+480 I16807E1920           LEVEL:
    Error
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, database utilities,
    sqluCCrossParser::zParseColumn, probe:3678
    MESSAGE : ZRC=0x87150054=-2028666796=SQLU_PRG_ERR "Program
    error"
              DIA8575C An index manager programming error occurred.
    DATA #1 : LOADID, PD_TYPE_LOADID, 56 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    DATA #2 : String, 19 bytes
    Parsing logic error
    DATA #3 : unsigned integer, 4 bytes
    1
    DATA #4 : unsigned integer, 8 bytes
    1
    DATA #5 : unsigned integer, 8 bytes
    2
    DATA #6 : Hexdump, 200 bytes
    0x00002AAB288701F0 : 0180 0100 0000 0000 1000 0000 0000 0000
    ................
    0x00002AAB28870200 : 2100 0000 0000 0000 0000 0000 0000 0000
    !...............
    0x00002AAB28870210 : 0100 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870220 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870230 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870240 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870250 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870260 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870270 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870280 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870290 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB288702A0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB288702B0 : 0000 0000 0000 0000
    ........
    
    
    A more detailed example:
    
    db2 connect to accdbdpf
    db2 "DECLARE C1 CURSOR DATABASE SZACC07 USER accdb2 USING
    'm)e*AtMM99nK2C' FOR SELECT * FROM
    ACCDBDPF.T_CHECK_KEYASSET_EMAIL_TRANSFER WITH UR"
    db2 "LOAD FROM C1 OF CURSOR REPLACE INTO
    ACCDBDPF.T_CHECK_KEYASSET_EMAIL_TRANSFER NONRECOVERABLE
    PARTITIONED DB CONFIG PARTITIONING_DBPARTNUMS(9,10,11,12)"
    
    db2diag.log will report error like following
    
    2017-07-04-12.10.36.386586+480 I10509E626            LEVEL:
    Warning
    PID     : 90621                TID : 46992860374784  PROC :
    db2sysc 4
    INSTANCE: accdb2               NODE : 004            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc01-db
    EDUID   : 21738                EDUNAME: db2lfrm0 4
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg,
    probe:315
    DATA #1 : String, 156 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    Starting LOAD phase at 07/04/2017 12:10:36.349992. Table
    ACCDBDPF.T_CHECK_KEYASSET_EMAIL_TRANSFER
    ....
    2017-07-04-12.11.12.878554+480 I16807E1920           LEVEL:
    Error
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, database utilities,
    sqluCCrossParser::zParseColumn, probe:3678
    MESSAGE : ZRC=0x87150054=-2028666796=SQLU_PRG_ERR "Program
    error"
              DIA8575C An index manager programming error occurred.
    DATA #1 : LOADID, PD_TYPE_LOADID, 56 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    DATA #2 : String, 19 bytes
    Parsing logic error
    DATA #3 : unsigned integer, 4 bytes
    1
    DATA #4 : unsigned integer, 8 bytes
    1
    DATA #5 : unsigned integer, 8 bytes
    2
    DATA #6 : Hexdump, 200 bytes
    0x00002AAB288701F0 : 0180 0100 0000 0000 1000 0000 0000 0000
    ................
    0x00002AAB28870200 : 2100 0000 0000 0000 0000 0000 0000 0000
    !...............
    0x00002AAB28870210 : 0100 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870220 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870230 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870240 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870250 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870260 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870270 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870280 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB28870290 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB288702A0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00002AAB288702B0 : 0000 0000 0000 0000
    ........
    2017-07-04-12.11.12.888202+480 I18728E732            LEVEL:
    Error
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, database utilities,
    sqluCCrossParser::zParseColumn, probe:3686
    MESSAGE : ZRC=0x87150054=-2028666796=SQLU_PRG_ERR "Program
    error"
              DIA8575C An index manager programming error occurred.
    DATA #1 : LOADID, PD_TYPE_LOADID, 56 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    DATA #2 : File name, 16 bytes
    sqlulxld_parse.C
    2017-07-04-12.11.12.891469+480 I19461E594            LEVEL:
    Error
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
    probe:0
    DATA #1 : String, 124 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    , -2028666796, (nil), Detected in file:sqlulxld_parse.C,
    Line:4241
    2017-07-04-12.11.12.894545+480 I20056E594            LEVEL:
    Error
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
    probe:0
    DATA #1 : String, 124 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    , -2028666796, (nil), Detected in file:sqlulxld_parse.C,
    Line:4972
    2017-07-04-12.11.12.896250+480 I20651E590            LEVEL:
    Error
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
    probe:0
    DATA #1 : String, 120 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    , -2028666796, (nil), Detected in file:sqlulxldmpp.C, Line:959
    2017-07-04-12.11.12.899694+480 I21242E623            LEVEL:
    Error
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
    probe:0
    DATA #1 : String, 153 bytes
    LOADID: 21696.2017-07-04-12.10.32.429433.1 (65530;32803)
    Failed to process end of record. , -2028666796, (nil), Detected
    in file:sqlusPartSA.C, Line:3692
    2017-07-04-12.11.12.902382+480 I21866E559            LEVEL:
    Severe
    PID     : 101569               TID : 46987701380864  PROC :
    db2sysc 12
    INSTANCE: accdb2               NODE : 012            DB   :
    ACCDBDPF
    APPHDL  : 1-3784               APPID: *N1.accdb2.170704041032
    AUTHID  : ACCDB2               HOSTNAME: dggacc03-db
    EDUID   : 19298                EDUNAME: db2lpart 12
    FUNCTION: DB2 UDB, global services, sqlzerdm, probe:40
    MESSAGE : ZRC=0x87150054=-2028666796=SQLU_PRG_ERR "Program
    error"
              DIA8575C An index manager programming error occurred.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * remote load from cursor                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply the special build                                      *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT35964

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-02-18

  • Closed date

    2021-03-14

  • Last modified date

    2021-03-14

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
15 March 2021