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

RRC 3.0.1 RC1 DB2 Setup

I need information on how to set up a database for DB2 Version 9.1 for RRC 3.0.1, are the old settings from RRC version 2 still the same?

To setup a DB2 database:
1. In Windows, open the DB2 Command Window by clicking Start > All Programs > IBM DB2 > Command Line Tools > Command Window.
2. Type the following command (only an example to create a new database called RRC) in the Command Window:
Windows users:
db2 create database RRC on c: using codeset UTF-8 territory en PAGESIZE 8192
Linux users:
db2 create database RRC using codeset UTF-8 territory en PAGESIZE 8192

I setup our RRC database like the discription above but get an error while trying to create tables in the webconfiguration of data warehouse.

Error when trying to create data warehouse tables:

com.ibm.team.repository.common.TeamRepositoryException: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:223) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSql(AbstractDataWarehouseDbProvider.java:93) at com.ibm.team.datawarehouse.service.db2.internal.DB2DataWarehouseDbProvider.createDataWarehouseCoreTables(DB2DataWarehouseDbProvider.java:32) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy387.createDataWarehouseCoreTables(Unknown Source) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:140) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$4.run(RemoteDatabaseService.java:211) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:350) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:201) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:116) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy46.createRemoteSchemas(Unknown Source) at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$12.run(InternalDataWarehouseService.java:1305) Caused by: com.ibm.team.repository.service.internal.UncheckedRepositoryException: com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A database connection error occurred. CRJAZ0265I The virtual storage or database resource is not available. SQL: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) Parameter 0: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) SQL Exception #1 SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.57.82 SQL State: 57011 Error Code: -973 at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:100) 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.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:171) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:70) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:208) ... 24 more Caused by: com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A database connection error occurred. CRJAZ0265I The virtual storage or database resource is not available. SQL: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) Parameter 0: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) SQL Exception #1 SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.57.82 SQL State: 57011 Error Code: -973 at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:99) ... 28 more Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.57.82 at com.ibm.db2.jcc.am.bd.a(bd.java:679) at com.ibm.db2.jcc.am.bd.a(bd.java:60) at com.ibm.db2.jcc.am.bd.a(bd.java:127) at com.ibm.db2.jcc.am.km.c(km.java:2506) at com.ibm.db2.jcc.am.km.d(km.java:2483) at com.ibm.db2.jcc.am.km.b(km.java:1903) at com.ibm.db2.jcc.t4.db.h(db.java:220) at com.ibm.db2.jcc.t4.db.b(db.java:46) at com.ibm.db2.jcc.t4.t.b(t.java:38) at com.ibm.db2.jcc.t4.sb.g(sb.java:114) at com.ibm.db2.jcc.am.km.db(km.java:1898) at com.ibm.db2.jcc.am.km.a(km.java:2899) at com.ibm.db2.jcc.am.km.e(km.java:985) at com.ibm.db2.jcc.am.km.execute(km.java:969) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:169) ... 26 more

does anyone have a solution on that problem or any idea why this error happen?

Thanks in advance.

0 votes



One answer

Permanent link
I need information on how to set up a database for DB2 Version 9.1 for RRC 3.0.1, are the old settings from RRC version 2 still the same?

To setup a DB2 database:
1. In Windows, open the DB2 Command Window by clicking Start > All Programs > IBM DB2 > Command Line Tools > Command Window.
2. Type the following command (only an example to create a new database called RRC) in the Command Window:
Windows users:
db2 create database RRC on c: using codeset UTF-8 territory en PAGESIZE 8192
Linux users:
db2 create database RRC using codeset UTF-8 territory en PAGESIZE 8192

I setup our RRC database like the discription above but get an error while trying to create tables in the webconfiguration of data warehouse.

Error when trying to create data warehouse tables:

com.ibm.team.repository.common.TeamRepositoryException: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:223) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSql(AbstractDataWarehouseDbProvider.java:93) at com.ibm.team.datawarehouse.service.db2.internal.DB2DataWarehouseDbProvider.createDataWarehouseCoreTables(DB2DataWarehouseDbProvider.java:32) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy387.createDataWarehouseCoreTables(Unknown Source) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:140) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$4.run(RemoteDatabaseService.java:211) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:350) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:201) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:116) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy46.createRemoteSchemas(Unknown Source) at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$12.run(InternalDataWarehouseService.java:1305) Caused by: com.ibm.team.repository.service.internal.UncheckedRepositoryException: com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A database connection error occurred. CRJAZ0265I The virtual storage or database resource is not available. SQL: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) Parameter 0: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) SQL Exception #1 SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.57.82 SQL State: 57011 Error Code: -973 at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:100) 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.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:171) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:70) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:208) ... 24 more Caused by: com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A database connection error occurred. CRJAZ0265I The virtual storage or database resource is not available. SQL: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) Parameter 0: ALTER TABLE TASK_REQUEST_LOOKUP ADD CONSTRAINT TSKISSU_FK1 FOREIGN KEY (TASK_ID) REFERENCES TASK (TASK_ID) SQL Exception #1 SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.57.82 SQL State: 57011 Error Code: -973 at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:99) ... 28 more Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.57.82 at com.ibm.db2.jcc.am.bd.a(bd.java:679) at com.ibm.db2.jcc.am.bd.a(bd.java:60) at com.ibm.db2.jcc.am.bd.a(bd.java:127) at com.ibm.db2.jcc.am.km.c(km.java:2506) at com.ibm.db2.jcc.am.km.d(km.java:2483) at com.ibm.db2.jcc.am.km.b(km.java:1903) at com.ibm.db2.jcc.t4.db.h(db.java:220) at com.ibm.db2.jcc.t4.db.b(db.java:46) at com.ibm.db2.jcc.t4.t.b(t.java:38) at com.ibm.db2.jcc.t4.sb.g(sb.java:114) at com.ibm.db2.jcc.am.km.db(km.java:1898) at com.ibm.db2.jcc.am.km.a(km.java:2899) at com.ibm.db2.jcc.am.km.e(km.java:985) at com.ibm.db2.jcc.am.km.execute(km.java:969) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:169) ... 26 more

does anyone have a solution on that problem or any idea why this error happen?

Thanks in advance.


Things have changed in the latest version. I have not tried a db2 install myself but there is a installation wizard that might help

http://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_wizard.html

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

Question asked: Apr 21 '11, 6:02 a.m.

Question was seen: 5,523 times

Last updated: Apr 21 '11, 6:02 a.m.

Confirmation Cancel Confirm