00C90081   

Explanation

An attempt was made to allocate a resource that is stopped for all access.

System action

The allocation process is not allowed.

Operator response

If this reason code appears in message DSNT500I or DSNT501I, determine whether the resource should be stopped.

If the resource should not be stopped, then use the -START DB db-name SPACENAM space-name command to start the object for R/W access.

User response

Determine when the resource is no longer stopped, and rerun the job or resubmit the command.

Problem determination

The requested operation is not performed. An SQLCODE -904 or -923 is issued, and/or message DSNT500I or message DSNT501I is issued.

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.
  • Listing of SYS1.LOGREC data set, obtained by executing IFCEREP1.
  • 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.