Db2 Error Codes 904
Contents |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register db2 error codes list mainframe before you can post: click the register link above to proceed. To
Db2 Error Codes 551
start viewing messages, select the forum that you want to visit from the selection below. Results 1
Db2 Error Codes 204
to 5 of 5 Thread: Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n904.html 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 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 http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour 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 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
MainFrame >> DB2 Suggest New Category What is -904 sql code? How to resolve it? http://www.allinterview.com/showanswers/137092/what-is-904-sql-code-how-to-resolve-it.html Question Posted / balakrishna 3 Answers 18130 Views I also Faced E-Mail Answers http://www.ibmmainframeforum.com/db2/sqlcode-unsuccessful-execution-t1321.html 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 db2 error the time 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 RW mode then may be the underlying dataset may have got deleted in that case we will need db2 error codes 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 = 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 popul
-904, ERROR: UNSUCCESSFUL EXECUTION IBM's flagship relational database management system Post a reply Previous topic • Next topic • 8 posts • Page 1 of 1 SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION by thiagorr » Wed Nov 26, 2008 9:47 am Hi!I'm creating 6 tables on a DB, with a few indexes and constraints...When I'm almost finishing, I can't use nothing else on these tables!Not the INSERT, neither INSERT commands are allowed!This is the return when a try de SELECT command, for example:Select allDSNE610I NUMBER OF ROWS DISPLAYED IS 0 DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C900A3, TYPE OF RESOURCE 00000200, AND RESOURCE NAME SMDB026 .SMTS026 DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 102 13172746 0 13223106 -974970878 12714050 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000066' X'00C9000A' X'00000000' X'00C9C4C2' DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+-----DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72 DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 1 DSNE621I NUMBER OF INPUT RECORDS READ IS 4 DSNE622I NUMBER OF OUTPUT RECORDS WRITTEN IS 26 I tried to use the CHECK DATA utility, but I think I must be doing something wrong.Could someone help me, please! thiagorr Posts: 12Joined: Wed Sep 10, 2008 11:23 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION Top Re: DATA CHECK by dick scherrer » Wed Nov 26, 2008 10:17 am Hello,I'm creating 6 tables on a DB, with a few indexes and constraints...Were the tables created successfully? Post the output that shows the successful creaton of the tables.When I'm almost finishing, I can't use nothing else on these tables!What does this tell me Please clarify.Not the INSERT, neither INSERT commands are allowed!If you create table and do not insert any data, you will not be able to select any rows. The best you could hope for is a 100 sqlcode. . .The -904 sounds like a load was running and failed. Or the load is still running.Suggest you talk with the dba to get on the right track. Hope this helps,d.sch. dick scherrer Glo