904 Db2 Error Mainframes
Contents |
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community SQLCODE -904 during insert Carlton Enuda SQLCODE db2 sql error sqlcode=-803 -904 during insert August 2, 2000 10:38 AM Hi list, Attempt to insert a
Sqlcode=-551 Db2
row into a table produces a -904 reason code 200. I checked the status of the tablespace and it is "A"ctive. I
Db2 Sql Error Sqlcode=-913
also checked the status for the table and it is blank (no parent index defined): (1) The catalog space column for the tablespace is zero '0' and I'll like to know if perhaps that is http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n904.html the reason for the -904 error I get while trying to insert into this table? (2) During load process for the same table, I receive a DSNU012 with return code = 8. I examine utility output for other error messages but nothing there could point me to the probable cause. Anybody come across this problem? Your response will be greatly appreciated. Carlton ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.idug.org/p/fo/et/thread=3728 http://www.hotmail.com craig patton Re: SQLCODE -904 during insert August 2, 2000 11:08 AM (in response to Carlton Enuda) Carlton, Can you print more of the message? The '0' in the catalog for space is NOT the cause of your problem. Check to see how many extents you have for your VSAM file, check the DASD volume it is allocated to and make sure there is space available for another extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column in 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 in 'normal' mode, is caused by some sort of space problem for 1 of the VSAM files being used for either the TS or 1 of the indexes. HTH, Craig Patton >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 > >Hi list, >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 also checked the >status
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: http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: Sqlcode = http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec523424.aspx -904, Error: Unsuccessful Execution Caused By An Unavailable Resour Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch db2 sql to Threaded Mode 08-18-03,17:50 #1 tvuma12 View Profile View Forum Posts Registered User Join Date Aug 2003 Posts 1 Unanswered: 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, db2 sql error 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 08-19-03,03:30 #2 sathyaram_s View Profile View Forum Posts Visit Homepage Super Moderator Join Date Aug 2001 Location UK Posts 4,650 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 o
+ productResults.length + resourceResults.length > 0 ? 'See all Search Results' : 'Full site search'}} > CA Support Online > KB Article SQL-904 REASON 00C90084 resource 4K for Merge/Modify SQL-904 REASON 00C90084 resource 4K for Merge/Modify Document ID:TEC523424 Last Modified Date:2/10/2016 ShowHide Technical Document Details Products CA Merge/Modify for DB2 for z/OS CA Database Management Solutions for DB2 for z/OS Releases CA Merge/Modify for DB2 for z/OS:Release:17.0.00 CA Merge/Modify for DB2 for z/OS:Release:18.0 CA Merge/Modify for DB2 for z/OS:Release:19.0 Components CA Merge/Modify for DB2 for z/OS Symptoms: CA Merge/Modify job fails during processing with the following errors: PMM0200E - AN SQL ERROR HAS OCCURRED This Error has Occurred in CSECT - MMA@SEL and DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000230, AND RESOURCE NAME 4K DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRSOR SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -115 13172746 0 13231826 -959250432 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF8D' X'00C9000A' X'00000000' X'00C9E6D2' X'C6D30000' X'00000000' SQL DIAGNOSTIC INFORMATION PMM0682E - Unexpected return code 00000008 from module MMA@SEL. Which resource is effected during this CA Merge/Modify process? Resolution: According to the SQLCODE = -904 ERRORthis indicates that there is a space problem with the work file tablespaces allocated with 4 KB page sizes. REASON 00C90084 TYPE 00000230 NAME 4K Work file database storage requirements vary depending on application use. Additional Information: Please review "The DB2 Admin Guide" section: Creating additional work file table spaces. Not what you were looking for? Search Again> Product Information Support by Product> Product Documentation> Communities Join a Community> Education Find training by product> Please help us improve! Will this information enable you to resolve your issue? Yes No Please tell us what we can do better. Char: Share × Contact us Privacy Policy Legal Notices Data Transfers Site Map Copyright © 2016 CA. All rights reserved.