How To Resolve Resource Unavailable Error In Db2
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 how to resolve 904 error in db2 with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship
Db2 Sql Error Sqlcode=-904 Sqlstate=57011
OpportunitiesJoin a CommunitySpeaker Community Any ideas how to resolve a -904, UNAVAILABLE RESOURCE. REASON 00C90084,
Db2 Sql Error Sqlcode=-911
RESOURCE 230, N Vidya (L&I-(c)BEA) Attuluri Any ideas how to resolve a -904, UNAVAILABLE RESOURCE. REASON 00C90084, RESOURCE 230, N May 24, 2007 07:53 AM
Db2 Sql Error Sqlcode=-905
Hi Okonita, One option is to create the index with DEFER YES and then run the REBUILD INDEX utility. This will not use 4K. Other is to size the 4K database accordingly. Regards Vidya -----Original Message----- From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Okonita Sent: Thursday, sqlcode 904 unavailable resource May 24, 2007 8:39 AM To: [login to unmask email] Subject: [DB2-L] Any ideas how to resolve a -904, UNAVAILABLE RESOURCE. REASON 00C90084, RESOURCE 230, NAME=4K Hi all, I have a 66.5 million rows table I have been trying to create an index over it. All I get from my effort is DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000230, AND RESOURCE NAME 4K. Yes, when I started the system was very very busy with a lot of applications hogging DB2 sort pool and other resources. So, I differed creating the index till later only to find I still have this problem when there should be less contention for resources. At any rate, what can I do (or say to my system guy) to resolve this issue? Is there any work around for this kind of problem? We are DB2 z/
MainFrame >> DB2 Suggest New Category What is -904 sql code? How to resolve it? Question Posted / balakrishna 3 Answers 18282 Views I also Faced E-Mail Answers Answers were Sorted based on User's Feedback http://www.allinterview.com/showanswers/137092/what-is-904-sql-code-how-to-resolve-it.html Answer / deepak -904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource- type, AND RESOURCE NAME reason-name Explanation: The SQL statement could not be executed because resource resource-name of type resource-type was not available at the time http://stackoverflow.com/questions/17297845/what-is-the-difference-between-db2-sql-codes-913-and-904-with-an-example for the reason indicated by reason-code. Try to display the stats of the table and check if it is in RW mode, If not use the required repair utility to get the table to RW mode. If the table is in db2 sql RW mode then may be the underlying dataset may have got deleted in that case we will need to do a dummy load to get those created. If that also doesnt work will need to drop and recreate the objects from TABLESPACE level. Ths above is for IBM DB2 for z/os. Correct me if Iam wrong Is This Answer Correct ? 2 Yes 0 No Answer / balne When querying or retrieving items or importing new items, the library server returns [LS RC db2 sql error = 7015, SQL RC = -904] DGL5050A: SQL error executing query. XQPE query: /ITA [@SEMANTICTYPE BETWEEN 1 AND 2]. Return code: 7015. Reason code: 0. Extended return code: - 904. Extended reason code: 0. (STATE) : [LS RC = 7015, SQL RC = -904] There is also a warning in the library server log: < DSNT404I SQLCODE = 162, SQLSTATE = > ICMPLSCP handleForeignKeys 06174 03/09 06:25:24.457 GMT ;09045111471478 16:10285a68c22:X7ea2 IFVTE WARNING-- Please perform CHECK DATA command on z/OS. Possible cause When adding a foreign key to an existing component type table (ICMUTnnnnnsss), SQLCode 162 is returned. DB2® places a table space into CHECK PENDING state if: Any table in that table space has ever been populated at any time. A foreign key is added or modified for any table in the table space. The library server performs and commits the foreign key creation. However, a warning message is written to the library server log to remind you to run the CHECK DATA DB2 utility so that tables and views in this table space can be accessed. Action Perform the CHECK DATA command: CHECK DATA TABLESPACE DATABASE NAME TABLESPACE NAME Additional information DB2 messages: SQLCode 162 +162 TABLESPACE database-name.tablespace-name HAS BEEN PLACED IN CHECK PENDING Explanation: The indicated table space is in check pending status because the ALTER TABLE statement was used to specify a referential constraint or a check constraint (while special register CURRENT RULES = 'DB2') on a populated table. The table space is not general
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 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question 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 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 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