00C90097   

Explanation

An attempt was made to allocate to a table space for update operations. However, the table space was marked as 'image copy' required, and updates are not allowed. This condition occurs as a result of any of the following operations:
  • Running a REORG LOG NO or LOAD LOG NO utility on the table space without running a copy that specifies FULL YES.
  • Execution of a RECOVER utility which specifies the TORBA or TOCOPY options, without following it with the required COPY utility.
  • Execution of a -TERM UTILITY command on a COPY utility that failed during the copy phase or was active in the copy phase. Until the COPY utility completes, SQL updates are not allowed because the integrity of the data would be compromised.
  • Execution of a MODIFY RECOVERY utility after all back up copies of the table space or data set were deleted from the SYSCOPY catalog table.
  • Execution of an ALTER TABLESPACE LOGGED command after updates on a not logged tablespace.

System action

The allocation process is not allowed.

User response

Run the COPY utility. However, if the table space is to be used for read-only access, or if recoverability of the data is not required, instead of taking a full image copy you can run the REPAIR utility and request that the image copy required condition be removed.

Problem determination

The requested operation is not performed. An SQLCODE -904 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.
  • 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.