Load utility may stuck in deadloop and couldn't be forced.
This happened because of the return code from sqluCrossFetchInto
Buffer is overwritten by other functions, so that the loop in
Load is not able to detect the error.
One of the possible db2diag.log would looks like:
YYYY-MM-DD-10.HH.MM.ss.nnnnnn LEVEL:Severe
PID :<pid> TID : 1 PROC :
db2agent (<db>) 0
INSTANCE: <instance> NODE : 000 DB : <db>
APPHDL : <apphdl> APPID: <appid>
AUTHID : <authid>
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:25
MESSAGE : SQLEU_STATE2_LOAD_ROLLBACK_PENDING state is set
YYYY-MM-DD-HH.MM.ss.nnnnnn LEVEL: Error
PID : <pid> TID : 1 PROC :
db2agent (<DB>) 0
INSTANCE: <instance> NODE : 000 DB : <db>
APPHDL : <apphdl> APPID: <appid>
AUTHID : <authid>
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA
#1 : String, 121 bytes
LOADID: 442630.2009-02-28-01.40.11.507255.0 (5;4) , -1224,
ffffffff8012006d, Detected in file:sqlulxld_fetch.C, Line:982
YYYY-MM-DD-HH.MM.ss.nnnnnn LEVEL: Error
PID : <pid> TID : 1 PROC :
db2agent (<DB>) 0
INSTANCE: <instance> NODE : 000 DB : <db>
APPHDL : <apphdl> APPID: <appid>
AUTHID : <authid>
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA
#1 : String, 113 bytes
LOADID: 442630.2009-02-28-01.40.11.507255.0 (5;4) ,
-2145779603, 0, Detected in file:sqlulxld_fetch.C, Line:1653
YYYY-MM-DD-HH.MM.ss.nnnnnn LEVEL: Error
PID : <pid> TID : 1 PROC :
db2agent (<DB>) 0
INSTANCE: <instance> NODE : 000 DB : <db>
APPHDL : <apphdl> APPID: <appid>
AUTHID : <authid>
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA
#1 : String, 113 bytes
LOADID: 442630.2009-02-28-01.40.11.507255.0 (5;4) ,
-2145779603, 0, Detected in file:sqlulxld_fetch.C, Line:1752
YYYY-MM-DD-HH.MM.ss.nnnnnn LEVEL: Error
PID : <pid> TID : 1 PROC :
db2agent (<DB>) 0
INSTANCE: <instance> NODE : 000 DB : <db>
APPHDL : <apphdl> APPID: <appid>
AUTHID : <authid>
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA
#1 : String, 147 bytes
LOADID: 442630.2009-02-28-01.40.11.507255.0 (5;4)
sqluFetchCursor: called while sqlcode -ve , -1224, 0, Detected
in file:sqlulxld_fetch.C, Line:941 |
