Hi,

I tried to insert one rows in the DB2 Table and got the following error.

INSERT INTO SMPAPA2.PPMMSS_FACLTY 0022009
(FACLTY_IDENT_NBR, LAST_UPDATE, LAST_TRANSMISSION, 0023009
RECORDS_RECEIVED, FILE_STATUS, SEQUENCE_NBR, INT_TYPE) 0024009
VALUES 0025009
(17787, CURRENT TIMESTAMP, CURRENT TIMESTAMP, 0, ' ', 0, 'P'); 0026009
---------+---------+---------+---------+---------+---------+---------+---------
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200, AND
RESOURCE NAME SMPAPA12.S020
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0

Thanks
Uma

Uma

Please look at the message reference for your platform ..

The resource type 200 refers to TableSpace

The reason code
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.


HTH

Sathyaram

Satyaram,

Which platform did this error occur on?

How can it be looked up? I looked it up in the message reference for unix and it indicatted that we should check the problem determination guide for MVS. It will help to know.

Thanks in advance.

That error is on os390 ...

For documentation, you start with

http://www-3.ibm.com/software/data/d...0/library.html

BTW, the error message you looked up , I believe is of DB2 Connect ... But original poster's has happened on OS/390 (The output looks like SPUFI's )

HTH

Sathyaram

Well I guess my question is if a container ran out of space in unix while the table was trying to load/insert data, would this result in a 904?

Also, I don't think the error is a db2connect error - it's the 0900-0999 range of errors and the first 4 deal with commit/processing errors.