|
Problem IC72064
|
Status: Geschlossen |
TWO OR MORE CONCURRENT INVOCATIONS OF SYSPROC.DB2LOAD FAIL WITH SQL3508. COLLIDE ON TEMP FILE db2p0t0.msg |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
If the sysproc.db2load system stored procedure is invoked
concurrently by two or more applications, even if these
applications are connected to different databases or dbm
instances on the same machine, they will attempt to use the same
temporary file. So one of them will fail with a "SQL3508N Error
in accessing a file or path".
A db2diag.log message showing the failure to access temp file
"db2p0t0.msg" can be seen in the db2diag.log:
2010-06-10-14.19.38.817428+480 E27875747E552 LEVEL: Warning
(OS)
PID : 15361 TID : 140606899443440PROC :
db2agent (SAMPLE) 0
INSTANCE: db2inst5 NODE : 000 DB : SAMPLE
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating
system return code
was "".
CALLED : OS, -, open OSERR: EACCES
(13)
DATA #1 : File name, 16 bytes
/tmp/db2p0t0.msg |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Unix users *
****************************************************************
* PROBLEM DESCRIPTION: *
* If the sysproc.db2load system stored procedure is invoked *
* concurrently by two or more applications, even if these *
* applications are connected to different databases or dbm *
* instances on the same machine, they will attempt to use the *
* same temporary file. So one of them will fail with a *
* "SQL3508N Error *
* in accessing a file or path". *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V 9.7 FP 4 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.10.2010
03.05.2011
03.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
