00D70013

Explanation

A required integrated catalog facility (ICF) catalog does not exist or is inaccessible. An attempt to access an integrated catalog facility (ICF) catalog entry for a cluster (data set) failed. This is probably a user error.

System action

A 'resource not available' code is returned to the user.

System programmer response

Take the following actions:
  • Check that the proper catalog name was specified and is available to Db2.
  • Check the associated DSNP012I message on the operator's console for the integrated catalog facility (ICF) return and reason codes.
  • See the description of DSNP012I.
  • Look for any related messages on the console sheet.
  • Refer to the appropriate MVS publication for a description of message IDC3009I.

User response

If you are unable to resolve the problem, notify the system programmer or database administrator.

Problem determination

Obtain the following to help you determine the cause of the problem:
  • Details of the request that resulted in this code
  • Contents of the SQLCA
Collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
  • Dynamic dump, taken to SYS1.DUMPxx data set, by Db2 (04E and 04F abends).
  • IDCAMS LISTCAT output for the ICF (VSAM) catalog that contains the Db2 subsystem catalog that defined the failing index or table.
  • Listing of the results produced by the SQL statements.
  • SYSPRINT output, including JCL, for the application program or batch job, and system messages that were issued. Make sure that MSGLEVEL=(1,1) on the JOB statement so that all diagnostic information is sent to SYSPRINT.
  • Definitions of views and tables involved in the error.