How To Resolve 904 Error In Db2
Contents |
DB2 Content Manager z/OS performance Technote (FAQ) Question This problem happens on z/OS. When I run a query with db2 sql error sqlcode=-904 sqlstate=57011 an OR clause that should return a lot of results, such as
Db2 Sql Error Sqlcode=-911
the following, '/Employee[.//Degree/@Degree = "MBA" OR .//Job/@JobCategory = "Manager"]' I get this exception: com.ibm.mm.sdk.common.DKUsageError: DGL5050A: SQL error executing
Db2 Sql Error Sqlcode=-905
query. XQPE query: /Employee[.//Degree/@Degree = "MBA" OR .//Job/@JobCategory = "Manager"]. Return code: 7015. Reason code: 0. Extended return code: -904. Extended reason code: 0.; ICM7015: During an SQL operation
Db2 Sql Error Sqlcode=-913
in the library server, an unexpected error occurred. For details on the error, refer to the database document. (SERVER RC) : 7015 at com.ibm.mm.sdk.server.DKResultSetCursorICM.throwSQLException(DKResultSetCursorICM.java:1072) at com.ibm.mm.sdk.server.DKResultSetCursorICM.prepareAndExecuteSp(DKResultSetCursorICM.java:893) at com.ibm.mm.sdk.server.DKResultSetCursorICM.prepareAndExecuteSp(DKResultSetCurso rICM.java:768) at com.ibm.mm.sdk.server.DKResultSetCursorICM.open(DKResultSetCursorICM.java:1159) at com.ibm.mm.sdk.server.DKResultSetCursorICM.Init(DKResultSetCursorICM.java:221) at com.ibm.mm.sdk.server.DKResultSetCursorICM.
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 sql error sqlcode=-927 insert Carlton Enuda SQLCODE -904 during insert August 2, 2000 10:38 AM Hi list, db2 sql error sqlcode=-922 Attempt to insert a row into a table produces a -904 reason code 200. I checked the status of the db2 sql error sqlcode=-305 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 http://www-01.ibm.com/support/docview.wss?uid=swg21233587 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. Carlton http://www.idug.org/p/fo/et/thread=3728 ________________________________________________________________________ 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 table prod
MainFrame >> DB2 Suggest New Category What is -904 sql code? How to resolve it? Question Posted / balakrishna 3 Answers 18283 Views I also http://www.allinterview.com/showanswers/137092/what-is-904-sql-code-how-to-resolve-it.html Faced E-Mail Answers Answers were Sorted based on User's Feedback 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 for the reason indicated by reason-code. Try to display the stats of the table and check db2 sql 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 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 db2 sql error 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 = 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