Db2 Error Unavailable Resource - 904
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
Db2 Error Code 904
insert Carlton Enuda SQLCODE -904 during insert August 2, 2000 10:38 AM Hi list, db2 sqlcode 904 Attempt to insert a row into a table produces a -904 reason code 200. I checked the status of the db2 error 818 tablespace and it is "A"ctive. I 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
Oracle Error 904
like to know if perhaps that is 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.
Sql Error 904
Carlton ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at 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 t
If this is your first visit, be sure to check out db2 sql error sqlcode=-904 sqlstate=57011 the FAQ by clicking the link above. You may
Db2 Sql Error Sqlcode=-911
have to register before you can post: click the register link above to proceed. db2 sql error sqlcode=-905 To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: http://www.idug.org/p/fo/et/thread=3728 Sqlcode = -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 to Threaded Mode 08-18-03,17:50 #1 tvuma12 View Profile View Forum Posts Registered User http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour 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, 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring http://stackoverflow.com/questions/17297845/what-is-the-difference-between-db2-sql-codes-913-and-904-with-an-example developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question http://www.mvsforums.com/helpboards/viewtopic.php?t=380&sid=9839d869d003e99b5f8200b7b2e642e6 x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up What is the difference between DB2 sql codes -913 and -904 with an example? [closed] up vote -3 down vote favorite What is the difference between DB2 sql codes -913 and -904 sql error with an example? db2 share|improve this question edited Jun 25 '13 at 14:09 Leons 1,186918 asked Jun 25 '13 at 12:50 Rahul khandelwal 112 closed as too broad by Andrew Barber Sep 4 '13 at 20:56 There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded db2 sql error to fit the rules in the help center, please edit the question. add a comment| 2 Answers 2 active oldest votes up vote 2 down vote An SQL code of -913 is UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name An SQL code of -904 is UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name A -913 is a deadlock, or two programs trying to get the same resource. The classic example is program 1 updating table B, then A; and program 2 updating table A, then B. Neither program can get to the second resource, so you have a deadlock. To prevent this, all of your programs must modify DB2 tables in the same order (A, then B). A -904 is an unavailable resource. A dropped table or a locked table. Both errors give you the name of the deadlocked resource or the unavailable resource. share|improve this answer answered Jun 25 '13 at 13:19 Gilbert Le Blanc 34.1k53272 add a comment| up vote 0 down vote -913 is SQL0913N Unsuccessful execution caused by deadlock or timeout. -904 is SQL0904N Unsuccessful execution caused by an unavailable resource. -904 is specific to DB2 for MVS. share|improve this answer answered Jun 25 '13 at 14:05 Leons 1,186918 add a comment| Not the answer you're looking for? Browse other q
Author Message NarsimhaBeginnerJoined: 03 Dec 2002Posts: 27Topics: 14 Posted: Tue Feb 04, 2003 7:38 am Post subject: -904 Sqlcode?? Hi, When I am selecting rows in a table from fileaid browse option, It is throwing the error -904(Unavailable resource). There is an online transaction which is accessing this table and performs some updates in the table. How to find exectly where the error is coming? I don't have access to DB2 commands option to display database. Or any transaction is holding the table? Please find the following info from Fileaid. SQLCODE: -904 ERROR : 00C90081.00000200.DAOMS03T.MP44001T Explanation: The SQL statement cannot be executed because a resource is not available. Your program has timed out. Check with other users and refer to the IBM DB2 Messages and Codes manual. Thanks, Narsimha Back to top kolusuSite AdminJoined: 26 Nov 2002Posts: 11544Topics: 74Location: San Jose Posted: Tue Feb 04, 2003 7:53 am Post subject: Narsimha, A -904 abend usually caused by an UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE Here in your case you also have the exact error message pertaining to -904. Code: Error:reason-code,resource-type,resource-name In your case it is Code: Error:00C90081.00000200.DAOMS03T.MP44001T Check this link for reason-code 00C90081 Check this link for resource-type 00000200 DAOMS03T.MP44001T is the table name. From the error messages I see that your table space DAOMS03T is STOPPED. So the table MP44001T cannot be accessed. So check with your DBA as to why the tablespace is stopped. Hope this helps... cheers kolusu Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours Page 1 of 1 Jump to:Select a forumAnnouncements----------------MVSFORUMS - AnnouncementsHelp Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & AGeneral----------------Tools and DownloadsIT NewsTechnical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF You cannot post new topics in th