502 to 606RC1 upgrade generated the error "CRJAZ0265E The database resource or the virtual storage is not available."
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
Jeff,