IBM Support

LI74677: A LOAD TERMINATE MIGHT FAIL WITH THE FOLLOWING: SQL3508N ERROR IN ACCESSING..."TEMP_FILE"... RC "1"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABSTRACT: A load terminate might fail with the following:
    SQL3508N Error in accessing a file or path of type "TEMP_FILE"
    during load or load query.  Reason code: "1"
    
    PROBLEM SUMMARY: If the temporary load files created by the load
    utility are missing/deleted from the "TEMP_FILE" location after
    a load has been interrupted, a load terminate may fail with
    SQL3508N RC 1 since it can't locate the files.  This problem
    occurs when LOAD is able to access the load.loc file (which
    resides in a load/DB2mmmmm.PID/DB2nnnnn.OID directory underneath
    the database directory), but the LOAD temporary directory (as
    specified by TEMPFILES PATH option),  is gone.  The load.loc
    file directs LOAD to look for files in the TEMP_FILE path, but
    LOAD cannot find the files.
    
    Note: mmmmm is the tablespace ID (in hexadecimal) and nnnnn is
    the table ID (in hexadecimal) of the table in question
    

Local fix

  • - Delete the load.loc file from the first directory
    (db_dir/load/DB2mmmmm.PID/DB2nnnnn.OID)
    - Then issue the LOAD TERMINATE.
    
    The LOAD TERMINATE will now be successful and will bring the
    table out of load pending state.
    
    NOTE: In a DPF system, delete the load.loc file from all nodes
    involved in the load.
    

Problem summary

  • ABSTRACT: A load terminate might fail with the following:
    SQL3508N Error in accessing a file or path of type "TEMP_FILE"
    during load or load query.  Reason code: "1"
    

Problem conclusion

  • fixed fp5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74677

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-16

  • Closed date

    2010-02-02

  • Last modified date

    2010-02-02

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

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

    IC62561 IC62567 IC62573 IC62575 IC62767

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       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":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 February 2010