00C9008B
Explanation
An attempt was made to create a database, but no DBIDs are available; that is, the system limit has been reached.
System action
The create is not allowed.
User response
DROP all unused databases, and rerun the job.
Problem determination
The requested operation is not performed. An SQLCODE -904 is issued, and/or message DSNT500I 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.