For LOAD Remote Fetch (i.e. load from remote cursor), LOAD
spawns/creates a process (db2lueff.exe) to fetch data from the
cursor. However, the child process may inherit file handles
including "load.msg" from its parent process (db2sysc.exe) on
Windows, so that one LOAD may fail to delete its own "load.msg"
while "db2lueff.exe" spawned by another concurrent LOAD in the
same instance inherits the file handle.
Here is a sample error output in db2diag.log:
2015-03-12-21.40.17.311000+540 I9259371F583 LEVEL: Error
PID : 1980 TID : 7464 PROC :
db2syscs.exe
INSTANCE: DB2_01 NODE : 000 DB :
P06024
APPHDL : 0-672 APPID: *LOCAL.DB2_01.150312123956
AUTHID : ADMINISTRATOR HOSTNAME: WINDOWS1
EDUID : 7464 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
probe:0
MESSAGE : Error deleting message file , -2029060074,
0000000000000000, Detected
in file:sqluqagt.C, Line:1777
2015-03-12-21.40.17.311000+540 I9259956F1152 LEVEL: Error
PID : 1980 TID : 7464 PROC :
db2syscs.exe
INSTANCE: DB2_01 NODE : 000 DB :
P06024
APPHDL : 0-672 APPID: *LOCAL.DB2_01.150312123956
AUTHID : ADMINISTRATOR HOSTNAME: WINDOWS1
EDUID : 7464 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluqagt, probe:1779
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address is NULL
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3508 sqlerrml:
70
sqlerrmc: TEMP_FILE 6
C:\DB2_01\NODE0000\SQL00001\load\DB200003.PID\DB200004.OID
sqlerrp : SQLUQAGT
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
