00C90085

Explanation

An internal limit for the number work file tables spaces that are being used for processing Db2 work files has been reached. The following situations are the likely reasons:

  • Too many concurrent transactions requiring use of temporary files.
  • Insufficient primary or secondary quantities defined for table spaces in the work file database.
  • Inadequate space allocated to the work file database.

System action

The requested operation is not performed. Message DSNT501I is issued with reason code 00C90085 and is possibly followed by SQLCODE -904.

User response

To resolve the situation, take one of the following actions:

  • Reduce the number of concurrent transactions.
  • Increase the primary or secondary quantity defined for the table spaces in the work file database.
  • Increase space allocated to the work file database.

Problem determination

SYS1.LOGREC contains information in the variable recording area (VRA) of the system diagnostic work area (SDWA). Significant fields for this code are: VRARRK13, VRARRK14, and VRARRK15. If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.

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.
  • SVC dump (or system dump), taken to SYS1.DUMPxx data set, as result of an operator-initiated dump command or SLIP trap exit.
  • A listing of the SYS1.LOGREC data set, obtained by executing IFCEREP1.
  • Source listing of the failing application program.
  • 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.
  • Precompiler listing of failing application program with SOURCE(YES) and XREF(YES) specified.