Com.ibm.db2.jcc.b.sqlexception Db2 Sql Error Sqlcode=-904
Contents |
-904, SQLSTATE: 57011, SQLERRMC: 00C900A3
Sqlcode=-904 Sqlstate=57011 In Db2
00C900A3; 00C900A3; 00000200; LOGCONTROL; 57011; SQLSTATE: 57011; database-transfer; check sqlcode=-904, sqlstate=57011, sqlerrmc=00c90081 pending; check data; check; feedback; db2; db2/z; db2/zOS Technote (troubleshooting) Problem(Abstract) When executing db2 sqlcode 964 sqlstate 57011 the WebSphere Portal ConfigEngine script 'database-transfer' to transfer the Portal data from Derby to DB2/zOS, it may fail at the Feedback database
How To Resolve 904 Error In Db2
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 [echo] FbkDbType = db2_zos [sqlproc] action: execute-sql-scripts [sqlproc] _________________________________________________________ [sqlproc] DbDomain: feedback
Sqlcode 904 Unavailable Resource
[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! [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
check pending status DB2; zOS; check sqlcode: -904, sqlstate: 57011 pending; portal fails to start; startup failure; SQLCODE: -904; SQLSTATE:
Sqlcode=-289 Sqlstate=57011
57011 Technote (troubleshooting) Problem The IBM WebSphere Portal startup is failing with the following db2 sql error sqlcode=-911 exception : DYNA1001I: WebSphere Dynamic Cache instance named ws/wps.mappingurl.LookupCache initialized successfully. [11/27/07 12:40:26:241 PST] 00000015 DataStoreCont E com.ibm.wps.datastore.impl.DataStoreContext handleException EJPDB0001E: Error occurred during database http://www-01.ibm.com/support/docview.wss?uid=swg21413739 access. Last SQL statement is [SELECT OID, CREATED, MODIFIED, LABEL, PARENT_OID, RESOURCE_TYPE, RESOURCE_OID FROM DBT4REL.URL_MAP_CTX WHERE (PARENT_OID IS NULL)]. com.ibm.wps.util.DataBackendException: EJPDB0001E: Error occurred during database access. Last SQL statement is [SELECT OID, CREATED, MODIFIED, LABEL, PARENT_OID, RESOURCE_TYPE, RESOURCE_OID FROM DBT4REL.URL_MAP_CTX WHERE (PARENT_OID IS NULL)]. ... Caused by: http://www-01.ibm.com/support/docview.wss?uid=swg21289649 com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C900A3;00000200;TABLESPACENAME .TS830A at com.ibm.db2.jcc.b.lf.b(lf.java:3267) Symptom Portal server fails to start with the SQL error codes mentioned despite having successfully completed a database transfer. Cause The SQL errors indicate an attempt was made to allocate a table space, index space, or a related index space while the table space or index space was in check pending status. Furthermore, the check pending status needs to be resolved before the operation will be allowed. Environment DB2 for zOS Resolving the problem Essentially, it is up to the database administrator to run a job that will clear out the check pending status. They should be aware of the following utilities that should help resolve this issue on the database: -- If the object is a table space with referential relationships, then run the CHECK DATA utility
If this is your first visit, be sure to check out http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To https://sys101.wordpress.com/2012/08/21/db2-sql-error-sqlcode-964-sqlstate57011-sqlerrmcnull/ start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: Sqlcode = db2 sql -904, Error: Unsuccessful Execution Caused 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 db2 sql error 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 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 Vi
Database | Websphere Process Server 1 Comment I saw this error message on my websphere process server [14/08/12 08:50:16:777 NZST] 00000f7f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl initialize FFDC0009I: FFDC opened incident stream file C:\Program Files\IBM\WebSphere\ProcServer\profiles\wps-profile\logs\ffdc\WPS1.AppTarget.soawpspr1-node.0_00000f7f_12.08.14_08.50.16_0.txt [14/08/12 08:50:16:793 NZST] 00000f7f ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file C:\Program Files\IBM\WebSphere\ProcServer\profiles\wps-profile\logs\ffdc\WPS1.AppTarget.soawpspr1-node.0_00000f7f_12.08.14_08.50.16_0.txt [14/08/12 08:50:16:793 NZST] 00000f7f XATransaction E J2CA0027E: An exception occurred while invoking prepare on an XA Resource Adapter from dataSource jms/BPECFC, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), data(0000013921c055fb0000000100026403e72eafcab229fa7e4f92b9d171aa4e9b182667390000013921c055fb0000000100026403e72eafcab229fa7e4f92b9d171aa4e9b18266739000000010000000000000000000000000003)}: javax.transaction.xa.XAException: CWSIC8007E: An exception was caught from the remote server with Probe Id 3-013-0010. Exception: . at com.ibm.ws.sib.comms.common.JFAPCommunicator.parseSingleException(JFAPCommunicator.java:1849) at com.ibm.ws.sib.comms.common.JFAPCommunicator.getException(JFAPCommunicator.java:1718) at com.ibm.ws.sib.comms.common.JFAPCommunicator.checkXACommandCompletionStatus(JFAPCommunicator.java:1671) at com.ibm.ws.sib.comms.client.OptimizedSIXAResourceProxy.prepare(OptimizedSIXAResourceProxy.java:809) at com.ibm.ws.sib.api.jmsra.impl.JmsJcaRecoverableSiXaResource.prepare(JmsJcaRecoverableSiXaResource.java:251) at com.ibm.ejs.j2c.XATransactionWrapper.prepare(XATransactionWrapper.java:1110) at com.ibm.ws.Transaction.JTA.JTAXAResourceImpl.prepare(JTAXAResourceImpl.java:208) at com.ibm.ws.Transaction.JTA.RegisteredResources.prepareResource(RegisteredResources.java:1410) at