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

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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 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