When loading from cursor with database option (Load Remote
Fetch), if there is no DELETE phase, Load might trap and crash
DB2 instance during the INDEX COPY phase.
You can see the following errors from db2diag.log:
2012-10-29-13.39.00.277586-300 I3210667A579 LEVEL: Error
PID : 18022488 TID : 1 PROC :
db2lueff
INSTANCE: sample NODE : 000
APPID : 157.146.32.89.45390.121029183900
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluffOpenOutputStream,
probe:283
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
memory addr"
DIA8561C A invalid memory block was encountered.
DATA #1 : String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address is NULL
DATA #2 : File name, 13 bytes
sqluueffApp.C
2012-10-29-13.39.00.289921-300 I3211247A623 LEVEL: Error
PID : 18022488 TID : 1 PROC :
db2lueff
INSTANCE: sample NODE : 000
APPID : 157.146.32.89.45390.121029183900
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluffMain, probe:2321
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
memory addr"
DIA8561C A invalid memory block was encountered.
DATA #1 : String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address is NULL
DATA #2 : File name, 13 bytes
sqluueffApp.C
DATA #3 : String, 27 bytes
Error opening output stream
... ...
2012-10-29-13.39.00.291626-300 I3213616A504 LEVEL: Warning
PID : 44957714 TID : 14253 PROC : db2sysc
0
INSTANCE: sample NODE : 000 DB : SAMPLE
APPHDL : 0-30372 APPID:
*LOCAL.db2ppp1p.121029173618
AUTHID : SAMPLE
EDUID : 14253 EDUNAME: db2lurex 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 9112.2012-10-29-12.36.22.735144.0 (8;961)
UserExitSA is done -2145779603, 0
... ...
2012-10-29-13.39.00.298634-300 I3215719A775 LEVEL: Error
PID : 44957714 TID : 14253 PROC : db2sysc
0
INSTANCE: sample NODE : 000
EDUID : 14253 EDUNAME: db2lurex 0
FUNCTION: DB2 UDB, database utilities,
sqlusCUserExitSubAgent::iRun, probe:1394
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 9112.2012-10-29-12.36.22.735144.0 (8;961)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : sqlcabc: 0 sqlcode: -83 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLUFFAP
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1)
... ...
2012-10-29-13.39.20.618199-300 I3218219A514 LEVEL: Warning
PID : 44957714 TID : 9112 PROC : db2sysc
0
INSTANCE: sample NODE : 000 DB : SAMPLE
APPHDL : 0-30372 APPID:
*LOCAL.db2ppp1p.121029173618
AUTHID : SAMPLE
EDUID : 9112 EDUNAME: db2agent (DB2PPP1P) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:600
DATA #1 : String, 33 bytes
bCleanUp__20sqluCMediaListServer
DATA #2 : String, 4 bytes
sqlu
The stack trace looks like the following:
sqluCMediaListServer::bCleanUp
sqluCleanupUserExitPipes
sqluCleanupUserExitCB
sqluAppCbCleanup
sqluCommitCallBack
sqlrrcom_dps
sqlrrcom
sqlrr_commit
sqluv_commit
sqlu_register_table_load
sqluvtld_route_in |
