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 |
