Users performing mulitple remote Loads on windows platform
may get SQL2036N error.
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: Warning
PID : 3676 TID : 348 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DB2TEST
APPHDL : 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 : DB2TEST
APPHDL : 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 : DB2TEST
APPHDL : 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: Warning
PID : 3676 TID : 348 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DB2TEST
APPHDL : 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 . |
