Start of change

00C90635   

Explanation

An attempt was made to allocate to a table space partition for update operations. However, the table space partition is in a Persistent Read Only (PRO) restricted status, and updates are not allowed. This condition occurs as a result of using the REPAIR utility to set the PRO restricted status for the purpose of prohibiting updates.

System action

The allocation process is not allowed.

User response

Check with the DB2® system administrator and the database administrator. Do not remove the PRO restricted status without their consent, because updates to the data might cause data loss.

Problem determination

The requested operation is not performed. SQL error code -904 or message DSNT501I is issued.

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 spanning 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 the system messages that were issued. Make sure that MSGLEVEL=(1,1) on the JOB statement so that all diagnostic information is sent to SYSPRINT.
End of change