Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

0 votes



One answer

Permanent link

 Jeff,



In case this help please mark the answer as accepted.

- Arne

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,495
× 2,357

Question asked: Jun 07 '18, 1:23 p.m.

Question was seen: 2,747 times

Last updated: Jun 10 '18, 10:57 a.m.

Confirmation Cancel Confirm