Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC63624 Status: Closed

ON WINDOWS PLATFORM, REMOTE LOAD MAY FAIL WITH "ACCESS DENIED"
ERROR

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
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 .
Problem Summary:
ON WINDOWS PLATFORM, REMOTE LOAD MAY FAIL WITH "ACCESS DENIED" 
ERROR.
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Fixed in DB2 v95FP6.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC66383 IC66522 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
07.10.2009
14.09.2010
14.09.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.