Users performing mulitple remote Loads on windows platform may
get error. Re-running the same load finishes fine. This APAR is
hit due to multiple remote loads started within very small
timeframe. db2diag log shows following messages:
2009-07-09-16.02.20.502000-300 I12235F491 LEVEL:
WarningPID : 3676 TID : 348 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB :
DB2TESTAPPHDL : 0-34 APPID:
192.29.1.1.41486.09090921021
AUTHID : TEST
EDUID : 348 EDUNAME: db2agent (DB2TEST) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in,
probe:837
DATA #1 : <preformatted>
Starting LOAD operation (R) (7) (R).
2009-07-09-16.02.20.877000-300 E13691F538 LEVEL: Error
(OS)
PID : 3676 TID : 348 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB :
DB2TESTAPPHDL : 0-34 APPID:
192.29.1.1.41486.09090921021
AUTHID : TEST
EDUID : 348 EDUNAME: db2agent (DB2TEST) 0
FUNCTION: DB2 UDB, oper system services, sqloCreateNamedPipe,
probe:84
MESSAGE : ZRC=0x83000005=-2097151995
CALLED : OS, -, CreateNamedPipe
OSERR : 5 "Access is denied."
2009-07-09-16.02.20.877000-300 I14231F589 LEVEL: Error
PID : 3676 TID : 348 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB :
DB2TESTAPPHDL : 0-34 APPID:
192.29.1.1.41486.09090921021
AUTHID : TEST
EDUID : 348 EDUNAME: db2agent (DB2TEST) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 142 bytes
LOADID: 348.2009-07-09-16.02.20.502000.0 (1095;2)
Unable to create pipe , -2097151995, 0000000000000063, Detected
in file:sqluPipe.C, Line:245
2009-07-09-16.02.20.877000-300 I14822F533 LEVEL:
WarningPID : 3676 TID : 348 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB :
DB2TESTAPPHDL : 0-34 APPID:
192.29.1.1.41486.09090921021
AUTHID : TEST
EDUID : 348 EDUNAME: db2agent (DB2TEST) 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 86 bytes
LOADID: 348.2009-07-09-16.02.20.502000.0 (1095;2)
\\.\pipe\db2loadpipe348.000.000 0, 0
Fix for this APAR will avoid the error on load . |
