Db2 Sql Error 904 Sqlstate 57011
Contents |
-904, SQLSTATE: 57011, SQLERRMC: 00C900A3 00C900A3; 00C900A3; 00000200; LOGCONTROL; 57011; SQLSTATE: 57011; database-transfer;
Db2 Sql Error Sqlcode 964 Sqlstate 57011
check pending; check data; check; feedback; db2; db2/z; db2/zOS Technote (troubleshooting) db2 sql error sqlcode 964 sqlstate 57011 sqlerrmc null driver 3.58 82 Problem(Abstract) When executing the WebSphere Portal ConfigEngine script 'database-transfer' to transfer the Portal data from
Db2 Sql Error Sqlcode 968 Sqlstate 57011
Derby to DB2/zOS, it may fail at the Feedback database domain with DB2 exceptions SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C900A3 Symptom In the ConfigTrace.log, the full how to resolve 904 error in db2 exception will be: ==================================== action-populate-feedback-database: [echo] DbDomain = feedback [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 db2 sql error sqlcode=-911 INTO feedback.LOGCONTROL (LogState, ReportServer, ReportSSL) VALUES [sqlproc] (0, 'localhost', 0) [sqlproc] Error during statement execution! [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: WebSphe
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Db2 Sql Error Sqlcode=-905
To start viewing messages, select the forum that you want to visit from the sqlcode 90m db2 selection below. Results 1 to 5 of 5 Thread: Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour Tweet
Db2 Sql Error Sqlcode=-803
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 http://www-01.ibm.com/support/docview.wss?uid=swg21413739 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 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 http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour 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, and updates are not allowed. This condition occurs as a result of any of the following: Running a REORG LOG NO or LOAD LOG NO utility on the table space without running a copy that specifies FULL YES. Execution of a RECOVER utility which specifies the TORBA or TOCOPY options, without following it with the required COPY utility. Execution of a -TERM UTILITY command on a COP
-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 http://www.ibmmainframeforum.com/db2/sqlcode-unsuccessful-execution-t1321.html 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 http://www.sqlerror.de/db2_sql_error_-904_sqlstate_57011.html NUMBER OF ROWS DISPLAYED IS 0 DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN db2 sql 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 db2 sql error = 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.No
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.