It's all about the answers!

Ask a question

502 to 606RC1 upgrade generated the error "CRJAZ0265E The database resource or the virtual storage is not available."


Jeff Ong (14113847) | asked Jun 07 '18, 1:23 p.m.
edited Jun 07 '18, 1:34 p.m.

While upgrading JTS from 5.0.2 to 6.0.6 RC1, we got the error below but it eventually displayed, "The data warehouse was upgraded successfully."  Should we be concerned ?

2018-06-07 11:00:05,130 CRRTC8039I The connection to the following data warehouse database was successful:
 DB Product Name: DB2/AIX64
  DB Product Version: SQL10059
  DB URL: //hostname.domain.ibm.com:60004/DW:user=xxxxxxxx;password=xxxxxxxx;
  JDBC Driver Name: IBM Data Server Driver for JDBC and SQLJ
  JDBC Driver Version: 4.21.29
2018-06-07 11:03:19,848 CRJAZ1318E The server could not connect to the database. Try the operation again.
CRJAZ0265E The database resource or the virtual storage is not available.

SQL: CREATE INDEX F_REQ_METR_IDX4 ON F_REQUEST_METRICS (REQUEST_TYPE_ID) ALLOW REVERSE SCANS
Parameter 0: CREATE INDEX F_REQ_METR_IDX4 ON F_REQUEST_METRICS (REQUEST_TYPE_ID) ALLOW REVERSE SCANS
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.21.29
SQL State: 57011
Error Code: -964


com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.21.29
        at com.ibm.db2.jcc.am.kd.a(kd.java:815)
        at com.ibm.db2.jcc.am.kd.a(kd.java:66)
        at com.ibm.db2.jcc.am.kd.a(kd.java:140)

[ ... removed stuff ... ]

        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
        at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
2018-06-07 11:03:41,209 The data warehouse was upgraded successfully.

One answer



permanent link
Ulf Arne Bister (1.3k413) | answered Jun 10 '18, 10:57 a.m.

 Jeff,



In case this help please mark the answer as accepted.

- Arne

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.