home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66383 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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 .
Problem-Zusammenfassung:
ON WINDOWS PLATFORM, REMOTE LOAD MAY FAIL WITH 
"ACCESS DENIED" ERROR
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 v9.7 FP2
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.02.2010
06.07.2010
06.07.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList