If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Posts: 1
Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour

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
Reply With Quote
  #2 (permalink)  
Old
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,649
Re: Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour

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
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Mar 2003
Posts: 343
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.
Reply With Quote
  #4 (permalink)  
Old
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,649
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

Quote:
Originally posted by cchattoraj
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.
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Mar 2003
Posts: 343
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On