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 |
