Db2 Sql Error Sqlcode=-904 Sqlstate=5701
Contents |
If this is your first visit, be sure to check out the FAQ by
Db2 Sql Error Sqlcode 407 Sqlstate 23502
clicking the link above. You may have to register before
Db2 Sql Error Sqlcode 440 Sqlstate 42884
you can post: click the register link above to proceed. To start viewing messages, select the db2 sql error sqlcode 551 sqlstate 42501 forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: Sqlcode = -904, Error: Unsuccessful Execution Caused By http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n904.html 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 Join Date Aug 2003 Posts 1 Unanswered: Sqlcode = -904, Error: http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour 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 Profile View Forum Posts Visit Homepage Super Moderator Join Date Aug 2001 Location UK Posts 4,650 Re: Sqlcode = -904, Error: Unsuccessful E
-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 http://www.ibmmainframeforum.com/db2/sqlcode-unsuccessful-execution-t1321.html I'm almost finishing, I can't use nothing else on these tables!Not the INSERT, neither INSERT commands are allowed!This http://www.sqlerror.de/db2_sql_error_-904_sqlstate_57011.html 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 db2 sql DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 102 13172746 0 13223106 -974970878 12714050 SQL DIAGNOSTIC INFORMATION db2 sql error 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.
V T 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. Refer to Table 3 in Appendix C, “Problem determination,” on page 757 for an explanation of resource type codes. Refer to Part 3, “DB2 codes,” on page 161 for an explanation of the given reason code. If this is issued in connection with Multilevel Security authorization (resource-type 402), then the Security Server return and reason codes for the unavailable resource appear as the resource-name. In this case, refer to the z/OS Security Server RACROUTE Macro Reference. System action: The SQL statement cannot be executed. If the SQL statement being executed was a cursor FETCH, DB2 closes the cursor. Subsequent attempts to use that cursor without first doing an OPEN for it <- BACK TO INDEX This is a free Service. I assume no warranty for misprints, and for the correctness and completeness of information and entries.