00C9008C   

Explanation

An attempt was made to allocate or bind to a partitioned table space for which no partitioning key was defined.

System action

The bind or allocation process is not allowed.

User response

Define the partitioning key or partitioning index for the partitioned table space, and rerun the job.

Problem determination

The requested operation is not performed. An SQLCODE -904 is issued, and/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.
  • Listing of DB2 catalog tables.
  • 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.
  • DB2 log output, including any DB2 recovery log archive tapes.
  • Definitions of views and tables involved in the error.