The reason code says an image copy is required.............
******************** Text Below Copyright (c) 2000, IBM
Explanation: An attempt was made to allocate to a table space for
operations. However, the table space was marked as 'image copy'
and updates are not allowed. This condition occurs as a result of
o Running a REORG LOG NO or LOAD LOG NO utility on the table
without running a copy that specifies FULL YES.
o Execution of a RECOVER utility which specifies the TORBA or
options, without following it with the required COPY utility.
o Execution of a -TERM UTILITY command on a COPY utility that
during the copy phase or was active in the copy phase. Until the
utility completes, SQL updates are not allowed because the the
integrity of the data would be compromised.
o Execution of a MODIFY utility after all back up copies of the
space or data set were deleted from the SYSCOPY catalog table.
System Action: The allocation process is not allowed.
User Response: Run the COPY utility. However, if the table space is
used for read-only access, or if recoverability of the data is
required, instead of taking a full image copy you can run the
utility and request that the image copy required condition be
------------------( Forwarded letter 1 follows
Date: Wed, 2 Aug 2000 12:55:48 EDT
To: [login to unmask email]
Sender: [login to unmask email]
Subject: Re: SQLCODE -904 during insert
Thanks for the response. Here's a screen print of the error
INSERT INTO PYT.PTMT_CUST_REF (ACCOUNT_ID, ROW_TIMESTAMP)
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY
UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200,
RESOURCE NAME DBPTTMT01 .PTCMT033
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050
DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000'
X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
>From: craig patton <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List
<[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: SQLCODE -904 during insert
>Date: Wed, 2 Aug 2000 16:08:27 GMT
>Can you print more of the message?
> The '0' in the catalog for space is NOT the cause of your
>to see how many extents you have for your VSAM file, check the
>it is allocated to and make sure there is space available for
>extent. Is this STOGROUP or VSAM defined? (A 'Y' in the
>SYSTABLESPACE indicates that it was created using a STOGROUP.)
If using a
>STOGROUP, check that all the volumes have space.
>I have found that most problems with a -904 and all objects are
>mode, is caused by some sort of space problem for 1 of the VSAM
>used for either the TS or 1 of the indexes.
>>From: Carlton Enuda <[login to unmask email]>
>>Reply-To: DB2 Data Base Discussion List
<[login to unmask email]>
>>To: [login to unmask email]
>>Subject: SQLCODE -904 during insert
>>Date: Wed, 2 Aug 2000 11:38:36 EDT
>>Attempt to insert a row into a table produces a -904 reason
code 200. I
>>checked the status of the tablespace and it is "A"ctive. I
>>status for the table and it is blank (no parent index
>>(1) The catalog space column for the tablespace is zero '0'
and I'll like
>>know if perhaps that is the reason for the -904 error I get
>>insert into this table?
>>(2) During load process for the same table, I receive a
>>code = 8. I examine utility output for other error messages
>>there could point me to the probable cause. Anybody come
>>problem? Your response will be greatly appreciated.
>>Get Your Private, Free E-mail from MSN Hotmail at
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com