MVSFORUMS.com

srikanth.bh · Beginner Joined: 23 Jul 2004 Posts: 8 Topics: 4

Hi all,

I am facing a problem while inserting a row through QMF and SPUFI.

Following is the error:

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:
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 the integrity of the data would be compromised.
Execution of a MODIFY utility after all back up copies of the table space or data set were deleted from the SYSCOPY catalog table.
This reason code is issued by the following CSECTs:

Any help would be highly appreciated.

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

You should be glad that DB2 stops you from changing table contents, that could not be recovered e.g. in the event of a disk failure. The tablespace has to have the status RW (read/write) without any restrictions for a successful insert of rows.

Since the status of "copy pending" or "recovery pending" was raised by the execution of a utility, go to your DBA and make it his (or her) task to find the owner of that utility processing or at least to remove the harming status from the tablespace.

regards
Christian