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.