It's all about the answers!

Ask a question

Problems setting up DB2 Datawarehouse


Emilio Iglesias Martinez (1666) | asked Mar 22 '12, 1:16 p.m.
Hi,

I'm using RTC Server version: 3.0.1.2
Migration from 3.0.1 has been performed following instructions in
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Froadmap_clm_upgrade.html

Everything is working well except the DataWarehouse part.
I did not use neither DataWarehouse nor DataMart with 3.0.1, but I wanted to start using the reporting functionlity now and therefore I got a new DB2 database setup.

When I run "repotools-jts.sh -createWarehouse" command, the following error is returned:

2012-03-22 17:34:39,433 CRJAZ1318I A database connection error occurred.

CRJAZ0265I The virtual storage or database resource is not available.
SQL: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
Parameter 0: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, DRIVER=3.57.82
SQL State: 57011
Error Code: -289

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, 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)

I noticed that H_BUILD_REQU_PASS table does not exist in the datawarehouse db.
Any hints about what might be producing this problem?

3 answers



permanent link
Morten Madsen (3053250) | answered Apr 23 '13, 3:47 p.m.
Sorry for reviving an old thread, but I think we needed the solution documented here. The solution is either to have the following in your server/conf/jts/teamserver.properties:

com.ibm.team.datawarehouse.db.base.folder=

That means "equals NOTHING"!! The default will be "/jazzdw" but this will not work.

You can also run /jts/setup and then remove the /jazzdw from the table space folder text box.

Comments
Anthony Kesterton commented Apr 23 '13, 4:05 p.m.
JAZZ DEVELOPER

No problem about reviving an old thread - it is great you have documented the way to fix the problem.


permanent link
Kim Soederhamn (1.5k34348) | answered Mar 27 '12, 8:15 a.m.
Hi,

I'm using RTC Server version: 3.0.1.2
Migration from 3.0.1 has been performed following instructions in
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Froadmap_clm_upgrade.html

Everything is working well except the DataWarehouse part.
I did not use neither DataWarehouse nor DataMart with 3.0.1, but I wanted to start using the reporting functionlity now and therefore I got a new DB2 database setup.

When I run "repotools-jts.sh -createWarehouse" command, the following error is returned:

2012-03-22 17:34:39,433 CRJAZ1318I A database connection error occurred.

CRJAZ0265I The virtual storage or database resource is not available.
SQL: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
Parameter 0: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, DRIVER=3.57.82
SQL State: 57011
Error Code: -289

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, 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)

I noticed that H_BUILD_REQU_PASS table does not exist in the datawarehouse db.
Any hints about what might be producing this problem?


Run the https://yourjtsserver:9334/jts/setup and on the datawarehouse pages enter the correct values - and click the create datawarehouse tables button there. I asume the driver is ok on your machine - eg that you are sing db2 for the other databases for jazz.

permanent link
Emilio Iglesias Martinez (1666) | answered Mar 28 '12, 11:49 a.m.
Hi,
running from jts/setup returns the same error.

The connection to the DB2 database is established successfully. The error appears during the "Create Tables" execution.

DB2 database structure has been setup using this commands:

CREATE BUFFERPOOL BPTEMP32K SIZE 4000 PAGESIZE 32768;
CREATE BUFFERPOOL BP_32K SIZE 8000 PAGESIZE 32768;

CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('$BASEDIRtempspace32k') BUFFERPOOL BPTEMP32K;
CREATE REGULAR TABLESPACE VNF_IDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvnf_idx.1' 5600) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;
CREATE REGULAR TABLESPACE VNF_32K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvnf_32k.1' 12000) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;
CREATE REGULAR TABLESPACE VSTR_IDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvstr_idx.1' 4000) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;
CREATE REGULAR TABLESPACE VSTR_32K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvstr_32k.1' 7200) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;

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.