Db2 Sql Error Sqlcode=-904 Sqlstate=57011
Contents |
-904, SQLSTATE: 57011, SQLERRMC: 00C900A3 00C900A3; 00C900A3; 00000200; LOGCONTROL; 57011; SQLSTATE: 57011; database-transfer; check pending; check data; check; feedback; sqlcode 904 sqlstate 57011 db2; db2/z; db2/zOS Technote (troubleshooting) Problem(Abstract) When executing the WebSphere Portal ConfigEngine
Db2 Sql Error Sqlcode 904 Sqlstate 57011 Sqlerrmc
script 'database-transfer' to transfer the Portal data from Derby to DB2/zOS, it may fail at the Feedback database db2 sql error sqlcode 964 sqlstate 57011 sqlerrmc null driver 3.58 82 domain with DB2 exceptions SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C900A3 Symptom In the ConfigTrace.log, the full exception will be: ==================================== action-populate-feedback-database: [echo] DbDomain = feedback
Db2 Sqlcode 289 Sqlstate 57011
[echo] FbkDbType = db2_zos [sqlproc] action: execute-sql-scripts [sqlproc] _________________________________________________________ [sqlproc] DbDomain: feedback [sqlproc] Database autocommit parameter false [sqlproc] Reading file /opt/IBM/WebSphere/wp_profile/ConfigEngine/config/work/pzn/db2_zos/fbk_Data.sql [sqlproc] Connected to jdbc:db2://mydb2zos.server.com:50000/fdbkdb [sqlproc] Setting database autocommit to:false [sqlproc] INSERT INTO feedback.LOGCONTROL (LogState, ReportServer, ReportSSL) VALUES [sqlproc] (0, 'localhost', 0) [sqlproc] Error during statement execution! how to resolve 904 error in db2 [sqlproc] com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C900A3;00000200;FDBKDB.FBTBSPCE [sqlproc] at com.ibm.db2.jcc.a.tf.d(tf.java:1397) [sqlproc] at com.ibm.db2.jcc.b.jb.l(jb.java:367) [sqlproc] at com.ibm.db2.jcc.b.jb.a(jb.java:64) ==================================== Cause The exception froms from the DB2/zOS system: SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C900A3;00000200;FDBKDB.FBTBSPCE It essentially means that the Tablespace mentioned in the SQLERRMC portion of the exception (in this case FDBKDB.FBTBSPCE) is in "check pending" state and unable to process requests. Normally, the database administrator can run "CHECK DATA" against the failing tablespace, but in this case CHECK DATA does not resolve the issue. The feedback transfer merely puts the tablespace back into 'check pending' status. This issue was ultimately caused by a corrupt tablespace. Resolving the problem To resolve this problem, drop and recreate the faulty tablespace. Once that is done, re-execute the database-transfer. Document information More support for: WebSphere Portal End of Support Products Installation & Configuration Software version: 6.1 Operating system(s): AIX, HP-UX, Linux, Solaris, Windows Software edition: Enable, Extend Reference #: 1413739 Modified date: 2015-10-30 Site availability Site assistance Contact and feedback Need supp
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may
Db2 Sql Error Sqlcode=-911
have to register before you can post: click the register link
Sqlcode 90m Db2
above to proceed. To start viewing messages, select the forum that you want to visit from the db2 sql error sqlcode=-905 selection below. Results 1 to 5 of 5 Thread: Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour Tweet Thread Tools Show Printable Version Subscribe to http://www-01.ibm.com/support/docview.wss?uid=swg21413739 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: Unsuccessful Execution Caused By An Unavailable Resour Hi, I tried to insert one rows in the DB2 http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour 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 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 alloc
-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, http://www.ibmmainframeforum.com/db2/sqlcode-unsuccessful-execution-t1321.html with a few indexes and constraints...When I'm almost finishing, I can't use nothing else on these tables!Not http://www.mvsforums.com/helpboards/viewtopic.php?t=380&sid=9839d869d003e99b5f8200b7b2e642e6 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 db2 sql 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 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 fo
Author Message NarsimhaBeginnerJoined: 03 Dec 2002Posts: 27Topics: 14 Posted: Tue Feb 04, 2003 7:38 am Post subject: -904 Sqlcode?? Hi, When I am selecting rows in a table from fileaid browse option, It is throwing the error -904(Unavailable resource). There is an online transaction which is accessing this table and performs some updates in the table. How to find exectly where the error is coming? I don't have access to DB2 commands option to display database. Or any transaction is holding the table? Please find the following info from Fileaid. SQLCODE: -904 ERROR : 00C90081.00000200.DAOMS03T.MP44001T Explanation: The SQL statement cannot be executed because a resource is not available. Your program has timed out. Check with other users and refer to the IBM DB2 Messages and Codes manual. Thanks, Narsimha Back to top kolusuSite AdminJoined: 26 Nov 2002Posts: 11544Topics: 74Location: San Jose Posted: Tue Feb 04, 2003 7:53 am Post subject: Narsimha, A -904 abend usually caused by an UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE Here in your case you also have the exact error message pertaining to -904. Code: Error:reason-code,resource-type,resource-name In your case it is Code: Error:00C90081.00000200.DAOMS03T.MP44001T Check this link for reason-code 00C90081 Check this link for resource-type 00000200 DAOMS03T.MP44001T is the table name. From the error messages I see that your table space DAOMS03T is STOPPED. So the table MP44001T cannot be accessed. So check with your DBA as to why the tablespace is stopped. Hope this helps... cheers kolusu Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours Page 1 of 1 Jump to:Select a forumAnnouncements----------------MVSFORUMS - AnnouncementsHelp Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & AGeneral----------------Tools and DownloadsIT NewsTechnical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum MVSFORUMS Powered by phpBB &cop