DB2 - Problem description
Problem IT21785 | Status: Closed |
DB2 LOAD FAILING IN DPF ENVIRONMENT DUE TO SQL0969N THERE IS NO MESSAGE TEXT CORRESPONDING TO SQL ERROR "-2769" | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When trying to load the the data in DPF environment using the ASC data file format, hit the following error: ERROR: SQL0969N There is no message text corresponding to SQL error "-2769" in the message file on this workstation. The error was returned from module "SQLULDAT" with original tokens "". The db2diag.log shows: 2016-02-24-15.17.28.709289-300 I540802684E838 LEVEL: Error PID : 18078 TID : 140611596314368PROC : db2sysc 1 INSTANCE: test1 NODE : 001 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser EDUID : 63789 EDUNAME: db2agent (test) 1 FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_init, probe:180 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1060 sqlerrml: 8 sqlerrmc: KUMADHEE sqlerrp : SQLRR003 sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFE3E (6) 0x00000001 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2016-02-24-15.17.28.709585-300 I540803523E518 LEVEL: Severe PID : 18078 TID : 140611596314368PROC : db2sysc 1 INSTANCE: test1 NODE : 001 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser EDUID : 63789 EDUNAME: db2agent (FTDW) 1 FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:140 RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT "SQLCA has already been built" 2016-02-24-15.17.30.256554-300 E540804042E558 LEVEL: Error (OS) PID : 18078 TID : 140633050179328PROC : db2sysc 1 INSTANCE: test1 NODE : 001 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser2 EDUID : 63745 EDUNAME: db2lpart 1 FUNCTION: DB2 UDB, oper system services, sqloPdbSendBuffer, probe:20 MESSAGE : ZRC=0x810F001C=-2129723364=SQLO_NO_CONNECTION "No connection" CALLED : OS, -, send OSERR: ECONNRESET (104) 2016-02-24-15.17.30.256849-300 I540804601E510 LEVEL: Severe PID : 18078 TID : 140633050179328PROC : db2sysc 1 INSTANCE: test1 NODE : 001 DB : test APPHDL : 1-2767 APPID: *.2.2.1.*.1 AUTHID : testuser2 EDUID : 63745 EDUNAME: db2lpart 1 FUNCTION: DB2 UDB, oper system services, sqloExecuteRemoteCommand, probe:5 DATA #1 : Hexdump, 4 bytes 0x00007FE7AEFFCBE0 : 1C00 0F81 .... 2016-02-24-15.17.30.256957-300 I540805112E498 LEVEL: Severe PID : 18078 TID : 140633050179328PROC : db2sysc 1 INSTANCE: test1 NODE : 001 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser1 EDUID : 63745 EDUNAME: db2lpart 1 FUNCTION: DB2 UDB, database utilities, sqluCSerializableSocket::iSendBuffer, probe:184 RETCODE : ZRC=0x810F001C=-2129723364=SQLO_NO_CONNECTION "No connection" 2016-02-24-15.17.30.257087-300 I540805611E569 LEVEL: Error PID : 18078 TID : 140633050179328PROC : db2sysc 1 INSTANCE: test1 NODE : 001 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser2 EDUID : 63745 EDUNAME: db2lpart 1 FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA #1 : String, 143 bytes LOADID: 58067.2016-02-24-15.17.33.894235.1 (12;2192) Failed to send buffer , -2129330063, (nil), Detected in file:sqlusBufferFormat.C, Line:536 2016-02-24-15.17.42.036517-300 I540807764E636 LEVEL: Error PID : 18934 TID : 140720597886720PROC : db2sysc 4 INSTANCE: test1 NODE : 004 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser2 EDUID : 63978 EDUNAME: db2lfrm2 4 FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2740 MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT "SQLCA has already been built" DATA #1 : LOADID, PD_TYPE_LOADID, 52 bytes LOADID: 58067.2016-02-24-15.17.33.894235.1 (12;2192) DATA #2 : File name, 10 bytes sqluedus.C 2016-02-24-15.17.42.036659-300 I540808401E690 LEVEL: Error PID : 18934 TID : 140720597886720PROC : db2sysc 4 INSTANCE: test1 NODE : 004 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser2 EDUID : 63978 EDUNAME: db2lfrm2 4 FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1775 MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT "SQLCA has already been built" DATA #1 : LOADID, PD_TYPE_LOADID, 52 bytes LOADID: 58067.2016-02-24-15.17.33.894235.1 (12;2192) DATA #2 : File name, 10 bytes sqluldat.C DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes 0x8015006D 2016-02-24-15.17.42.036912-300 I540809092E579 LEVEL: Error PID : 18934 TID : 140720597886720PROC : db2sysc 4 INSTANCE: nyqxt470 NODE : 004 EDUID : 63978 EDUNAME: db2lfrm2 4 FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1794 MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT "SQLCA has already been built" DATA #1 : LOADID, PD_TYPE_LOADID, 52 bytes LOADID: 58067.2016-02-24-15.17.33.894235.1 (12;2192) DATA #2 : File name, 10 bytes sqluldat.C DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes 0x8015006D 2016-02-24-15.17.42.037058-300 I540809672E579 LEVEL: Error PID : 18934 TID : 140720597886720PROC : db2sysc 4 INSTANCE: test1 NODE : 004 EDUID : 63978 EDUNAME: db2lfrm2 4 FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1797 MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT "SQLCA has already been built" DATA #1 : LOADID, PD_TYPE_LOADID, 52 bytes LOADID: 58067.2016-02-24-15.17.33.894235.1 (12;2192) DATA #2 : File name, 10 bytes sqluldat.C DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes 0x8015006D 2016-02-24-15.17.33.463875-300 I540810252E460 LEVEL: Warning PID : 18934 TID : 140715698939648PROC : db2sysc 4 INSTANCE: test1 NODE : 004 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser2 EDUID : 63985 EDUNAME: db2lfrm9 4 FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3182 MESSAGE : Interrupt received in formatter 9. 2016-02-24-15.17.42.037319-300 I540810713E566 LEVEL: Error PID : 18934 TID : 140712389633792PROC : db2sysc 4 INSTANCE: test1 NODE : 004 DB : test APPHDL : 1-8919 APPID: *.2.2.1.*.1 AUTHID : testuser2 EDUID : 63991 EDUNAME: db2lfrm15 4 FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA #1 : String, 139 bytes LOADID: 58067.2016-02-24-15.17.33.894235.1 (12;2192) Error riddifying records. , -2112552874, (nil), Detected in file:sqluldat.C, Line:4545 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT15864 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 24.10.2017 24.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |