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 IT07576 Status: Geschlossen

CONCURRENT LOAD IN SAME TABLE ON MULTIPLE PARTITIONS IN DPF MAY ABORT WITH:
SQL3508N ERROR IN ACCESSING A FILE OR PATH OF TYPE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
On DPF systems only: A concurrent load into the same table, 
running on different partitions, might abort with SQL3508N if 
the "TEMPFILES PATH" option specifies the same directory for the 
load jobs. 
 
The error that the LOAD receives: 
 
SQL3508N  Error in accessing a file or path of type "TEMP_FILE" 
during load or load query.  Reason code: "1". 
 
And some db2diag.log entries: 
 
2014-09-15-07.23.08.421072+120 I942222A542        LEVEL: Error 
PID     : 62390586             TID  : 3206        PROC : db2sysc 
2 
INSTANCE: db2inst1             NODE : 002         DB   : 
DATABASE 
APPHDL  : 2-12182              APPID: *N0.db2inst1.1411041422379 
AUTHID  : USER 
EDUID   : 3206                 EDUNAME: db2linit 2 
FUNCTION: DB2 UDB,  utilities, DIAG_ERROR, probe:0 
DATA #1 : String, 124 bytes 
LOADID: 46228.2014-09-15-07.23.07.488042.2 (4;361) 
sqloopen() failed , -2029060079, 0, Detected in file:sqlulmsg.C, 
Line:120 
 
2014-09-15-07.23.08.421765+120 I942765A545        LEVEL: Error 
PID     : 62390586             TID  : 3206        PROC : db2sysc 
2 
INSTANCE: db2inst1             NODE : 002         DB   : 
DATABASE 
APPHDL  : 2-12182              APPID: *N0.db2inst1.1411041422379 
AUTHID  : USER 
EDUID   : 3206                 EDUNAME: db2linit 2 
FUNCTION: DB2 UDB,  utilities, DIAG_ERROR, probe:0 
DATA #1 : String, 127 bytes 
LOADID: 46228.2014-09-15-07.23.07.488042.2 (4;361) 
Error creating File , -3006, 0, Detected in 
file:sqlufile_shadow.C, Line:282 
 
2014-09-15-07.23.08.422185+120 I943311A1073       LEVEL: Error 
PID     : 62390586             TID  : 3206        PROC : db2sysc 
2 
INSTANCE: db2inst1             NODE : 002         DB   : 
DATABASE 
APPHDL  : 2-12182              APPID: *N0.db2inst1.1411041422379 
AUTHID  : USER 
EDUID   : 3206                 EDUNAME: db2linit 2 
FUNCTION: DB2 UDB,  utilities, sqluRegisterLoadStart, probe:3573 
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT 
          "SQLCA has already been built" 
DATA #1 : LOADID, PD_TYPE_LOADID, 50 bytes 
LOADID: 46228.2014-09-15-07.23.07.488042.2 (4;361) 
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -3508   sqlerrml: 
64 
 sqlerrmc: TEMP_FILE 1 
/spool/temp/DB200004.PID/DB200169.OID/load0002 
 sqlerrp : SQLUCTLF 
 sqlerrd : (1) 0x8015006D      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0x00000000      (6) 
0x00000002 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
... 
 
2014-09-15-07.23.08.458503+120 E956445A798        LEVEL: Error 
(OS) 
PID     : 62390586             TID  : 46228       PROC : db2sysc 
2 
INSTANCE: db2inst1             NODE : 002         DB   : 
DATABASE 
APPHDL  : 2-12182              APPID: *N0.db2inst1.1411041422379 
AUTHID  : USER 
EDUID   : 46228                EDUNAME: db2agent (DATABASE) 2 
FUNCTION: DB2 UDB, oper system services, sqlormdir, probe:10 
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." 
          DIA8411C A file "" could not be found. 
CALLED  : OS, -, rmdir 
OSERR   : ENOENT (2) "No such file or directory" 
DATA #1 : String, 43 bytes 
/spool/temp/DB200004.PID/DB200169.OID
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7.                      * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 Version 10.5 Fix Pack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.03.2015
20.01.2016
20.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList