Com.ibm.db2.jcc.am.sqlexception Db2 Sql Error Sqlcode=-811
Contents |
WITH DB2 SQL ERROR: SQLCODE=-811. sqlcode=-811 sqlstate=21000 db2 AIX Direct links to fixes Tivoli Storage Productivity Center db2 sql error sqlcode=-811 sqlstate=21000 sqlerrmc=null Refresh Pack 4 Fix Pack 5.2.4 (November 2014) for Tivoli Storage Productivity Center Fix
Sqlcode 811 In Db2
Pack 5.2.4.1 (December 2014) for Tivoli Storage Productivity Center Refresh Pack 5.2.5 (March 2015) for Tivoli Storage Productivity Center Fix Pack 5.2.5.1
Sqlcode=-818
(April 2015) for Tivoli Storage Productivity Center Refresh Pack 5.2.6 (June 2015) for Tivoli Storage Productivity Center Refresh Pack 5.2.7 (August 2015) for Tivoli Storage Productivity Center IBM Spectrum Control V5.2.8 (December 2015) IBM Spectrum Control V5.2.9 (February 2016) IBM Spectrum Control V5.2.10 (May 2016) sql error code 811 IBM Spectrum Control V5.2.10.1 (July 2016) IBM Spectrum Control V5.2.11 (August 2016) Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description Fabric probe fails with DB2 SQL Error: SQLCODE=-811. The fabric probe logs will show: 2014-09-11 16:10:25.293-0500 BTAFM0604I Collection of switch fcports completed. 64 entities collected in total for switch xxxxxxxxxxxxxxxx. 2014-09-11 16:10:25.559-0500 BTAFM0602I Collection of switch blades completed. 10 entities collected in total for switch xxxxxxxxxxxxxxxx. 2014-09-11 16:10:30.551-0500 com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000, SQLERRMC=null, DRIVER=3.65.77 at com.ibm.db2.jcc.am.cd.a(cd.java:701) at com.ibm.db2.jcc.am.cd.a(cd.java:60) at com.ibm.db2.jcc.am.cd.a(cd.java:127) at com.ibm.db2.jcc.am.jo.b(jo.java:2420) at com.ibm.db2.jcc.am.jo.c(jo.java:2403) at com.ibm.db2.jcc.t4.ab.l(ab.java:370) at com.ibm.db2.jcc.t4.ab.a(ab.java:62) at com.ibm.db2.jcc.t4.p.a(p.java:50) at com.ibm.db2.jcc.t4.rb.b(rb.java:220) at com.ibm.db2.jcc.am.ko.nc(ko.java:3414) at com.ibm.db2.jcc.am.ko.b(ko.java:4377) at com.ibm.db2.jcc.am.ko.fc(ko.java:782) at com.ibm.db2.jcc.am.ko.executeUpdate(ko.java:760) at com.ibm.tpc.infrastructure.database.DBPreparedStatement.executeU pdate(DBPreparedStatement.java:261) at com.ibm.tpc.infrastructure.database.ComplexQuery.sqlUpdate(Compl exQuery.java:86) at com.ibm.tpc.common.dbaccess.FabricDbAccess.setParentPort2PortID( FabricDbAccess.java:25246) at com.ibm.tpc.fabric.collection.FabricProbeUtility.persistTopology Blade(FabricProbeUtility.java:4295) at com.ibm.tpc.fabric.collection.ProbeFabricTopologyEnumProcess.pop ulateData(ProbeFabricTopologyEnumProcess.java:2601) at com.ibm.tpc.fabric.collection.ProbeFabricTopologyEnumProcess.pro cessProxyTopologyInBlades(ProbeFabricTopologyEnumProcess.java:23 68) at com.ibm.tpc.fabric.collection.ProbeFabricTopologyEnumProcess.pro cess(P
RESULTS IN
911 Sqlcode
THE QUERY RETURNS MULTIPLE ROWS. Subscribe You can sqlcode-811 mainframe track all active APARs for this component. APAR status Closed as fixed if sqlcode sqlstate 21000 next. Error description Error message: SqlException: DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000 When running the report, that following error message is http://www.ibm.com/support/docview.wss?uid=swg1IT04591 in the GUI report's log that should display the result. This is the result of the report in TPC GUI, in the log file: Name_BRDataCollector.xxxxxx.log it is the same, without the error mesage: SRV0948E and SRV0967E: 11/5/13 3:16:06 AM STS0306I: Job queued http://www.ibm.com/support/docview.wss?uid=swg1IC97510 for processing. Waiting for idle thread. 11/5/13 3:16:06 AM SRV0942I: Data collection started. com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000, SQLERRMC=null, DRIVER=3.53.95 at com.ibm.db2.jcc.b.bd.a(bd.java:679) at com.ibm.db2.jcc.b.bd.a(bd.java:60) at com.ibm.db2.jcc.b.bd.a(bd.java:127) at com.ibm.db2.jcc.b.vl.b(vl.java:3717) at com.ibm.db2.jcc.b.vl.a(vl.java:3699) at com.ibm.db2.jcc.t4.db.a(db.java:730) at com.ibm.db2.jcc.t4.db.m(db.java:719) at com.ibm.db2.jcc.t4.db.i(db.java:244) at com.ibm.db2.jcc.t4.db.c(db.java:52) at com.ibm.db2.jcc.t4.t.c(t.java:44) at com.ibm.db2.jcc.t4.sb.i(sb.java:153) at com.ibm.db2.jcc.b.gm.db(gm.java:1984) at com.ibm.db2.jcc.b.gm.a(gm.java:2801) at com.ibm.db2.jcc.b.gm.a(gm.java:604) at com.ibm.db2.jcc.b.gm.executeQuery(gm.java:588) at com.tivoli.itsrm.San.repository.RptStorageSpace.ssToFileSystem(R ptStorageSpace.java:992) at com.tivoli.itsrm.San.repository.RptStorageSpace.getReportData(Rp tStorageSpace.java:1469) at com.tivoli.itsrm.BatchReporting.BRReportHndlr.handle(BRReportHnd lr.java:305) at com.tivoli.itsrm.BatchReporting.BRDataCollector.collectData(BRDa taCollector.java:382) at com.tivoli.itsrm.BatchReporting.BRDataCollector.executeBatchRepo rt(BRDataCollector.java:342) at com.tivoli.itsrm.BatchReporting.BRDataCollector.run(BRDataCollec tor.java:262) at com.tivoli.itsrm.TStorm.server.svp.JobHndlrThread.run(JobHndlrTh read.java:96) at java.lang.Thread.run(Thread.java:811) 11/5/13 3:16:26 AM SRV0948E: Error collecting data: check Server log for a detailed error message. 11/5/13 3:16:26 AM SRV0967E: There was a Server error when collecting data: 11/5/13 3:16:26 AM SRV0081E: SQL error. Unable to access table t_res_storage_subystem+ Stmt Type: SELECT, Stmt Phase: EXECUTE SQLSTATE: 21000, Vendor error code: -8
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more http://stackoverflow.com/questions/26072235/case-clause-on-select-clause-throwing-sqlcode-811-sqlstate-21000-error about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack https://jazz.net/forum/questions/56158/solved-configure-rtc-3001-with-db2 Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up CASE Clause on select clause throwing 'SQLCODE=-811, SQLSTATE=21000' Error up vote sql error 0 down vote favorite This query is very well working in Oracle. But it is not working in DB2. It is throwing DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000, SQLERRMC=null, DRIVER=3.61.65 error when the sub query under THEN clause is returning 2 rows. However, my question is why would it execute in the first place as my WHEN clause turns to be false always. SELECT CASE WHEN (SELECT COUNT(1) FROM STOP db2 sql error ST, FACILITY FAC WHERE ST.FACILITY_ID = FAC.FACILITY_ID AND FAC.IS_DOCK_SCHED_FAC=1 AND ST.SHIPMENT_ID = 2779) = 1 THEN (SELECT ST.FACILITY_ALIAS_ID FROM STOP ST, FACILITY FAC WHERE ST.FACILITY_ID = FAC.FACILITY_ID AND FAC.IS_DOCK_SCHED_FAC=1 AND ST.SHIPMENT_ID = 2779 ) ELSE NULL END STAPPFAC FROM SHIPMENT SHIPMENT WHERE SHIPMENT.SHIPMENT_ID IN (2779); sql db2 case share|improve this question edited Sep 27 '14 at 8:20 marc_s 450k918621027 asked Sep 27 '14 at 7:07 user2661315 111 Which version of db2 are you using? –Joachim Isaksson Sep 27 '14 at 8:17 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote The SQL standard does not require short cut evaluation (ie evaluation order of the parts of the CASE statement). Oracle chooses to specify shortcut evaluation, however DB2 seems to not do that. Rewriting your query a little for DB2 (8.1+ only for FETCH in subqueries) should allow it to run (unsure if you need the added ORDER BY and don't have DB2 to test on at the moment) SELECT CASE WHEN (SELECT COUNT(1) FROM STOP ST, FACILITY FAC WHERE ST.FACILITY_ID = FAC.FACILITY_ID AND FAC.IS_DOCK_SCHED_FAC=1 AND ST.SHIPMENT_ID = 2779) = 1 THEN (SELECT ST.FACILITY_ALIAS_ID FROM STOP ST, FACILITY FAC WHERE ST.FACILITY_ID = FAC.FACILITY_ID AND FAC.IS_DOCK_SCHED_FAC=1 AND ST.SHIPMENT_ID
×35,502 Asked: May 27 '11, 5:30 a.m. Seen: 7,170 times Last updated: May 27 '11, 5:30 a.m. Related questions Can a build start another build Pre filled editor presentations Disaster Recovery Plan for RTC (Backup and restore) Invoking a REST service from an Eclipse AttributePart Review option for Test Case Execution Records IBM RAD 9.0 and RTC 4.0.x on OSX workItem Query on specific approver and specific approval type Build Definition How can I use a secure Oracle port for my CLM Repositories? ClearCase connector for M4 FAQ - How this Forum works SOLVED: Configure RTC 3.0.0.1 with DB2 2 pere irazusta (206●18●20) | asked May 27 '11, 5:30 a.m. Hi, I am having some problems doing the setup of CCM on a Win2k3 Server. I've installed everything OOTB except by i'm using a db2-express database. I haven't had problems with the JTS installation part. The problem is when i try to configure the CCM Database. I 've created a specific database with DB2 for CCM, I tested the connection and it worked fine. The problem is when, following the steps shown, i try to create the tables to enable CCM work it shows an error saying it can't crete those tables: com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I Se ha producido un error de conexin de base de datos. CRJAZ0265I El almacenamiento virtual o el recurso de la base de datos no estn disponibles. SQL: CREATE LARGE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file 'jazzdata' 250000) AUTORESIZE YES DROPPED TABLE RECOVERY OFF SQL Exception #1 SQL Message: DB2 SQL Error: SQLCODE=-968, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.57.82 SQL State: 57011 Error Code: -968 at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:99) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.logAndReturnException(StatementErrLogWrapper.java:66) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:67) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeak