IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 11.                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 11.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT04775

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-07

  • Closed date

    2015-10-09

  • Last modified date

    2015-10-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT07576

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 October 2015