DB2 - Problem description
Problem IT35964 | Status: Closed |
REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem 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. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * remote load from cursor * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply the special build * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * remote load from cursor * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply the special build * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.02.2021 14.03.2021 14.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |