Db2 Sql Error Sqlcode=-904 Sqlstate=57011 Sqlerrmc
Contents |
If this is your first visit, be sure to check out the FAQ by sqlcode 90m db2 clicking the link above. You may have to register before db2 sql error sqlcode=-803 you can post: click the register link above to proceed. To start viewing messages, select db2 sql error sqlcode=-911 the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: Sqlcode = -904, Error: Unsuccessful Execution Caused http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n904.html 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 Join Date Aug 2003 Posts 1 Unanswered: Sqlcode = -904, http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour 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 Profile View Forum Posts Visit Homepage Super Moderator Join Date Aug 2001 Location UK Posts 4,650 Re: Sqlcode = -904,
-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 http://www.ibmmainframeforum.com/db2/sqlcode-unsuccessful-execution-t1321.html 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 db2 sql 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 db2 sql error 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 ro