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

RQM 2.0 DB2 repotools.sh -createTables SQL error

I have just downloaded the release version of RQM 2.0 and installed in on SLES 11. I am also using DB2 v9.7. I tried to install RQM into DB2 by the instructions and received this error:

db-rational:/opt/IBM/RQM20/server # ./repotools.sh -createTables
Repo Tools
Rational Quality Manager, Version 2.0 (I20090713_1659)
Jazz Foundation Server, Version 1.0 (I20090618-1753)

Provisioning using "./conf/jazz/provision_profiles".
Rational Jazz Team Server (RQM) - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //localhost:50003/rqm:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/LINUX
Db Product Version: SQL09070
Db URL: jdbc:db2://localhost:50003/rqm
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
Creating the tables for the database "//localhost:50003/rqm:user=xxxxxxxx;passwo rd=xxxxxxxx;" with indices.
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep aring or executing statement => CREATE TABLE LM.ABSTRACT_INSTANCE(STATE_ID CHAR( 23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, FAMILY_ITEM_ID CHAR(2 3) NOT NULL, VISIBILITY BIGINT NOT NULL, JZ_DISCRIMINATOR INTEGER NOT NULL, CPU_ CPU_CORES_INSTALLED INTEGER, CPU_CPU_DIES_INSTALLED INTEGER, CPU_CPU_SPEED INTEG ER, CPU_CPU_COUNT INTEGER, CPU_CPU_MANUFACTURER VARCHAR(250), CPU_CPU_ARCHITECTU RE_WIDTH VARCHAR(250), CPU_CPU_ARCHITECTURE VARCHAR(250), IP_INTERFACE_IP_V4_ADD RESS VARCHAR(250), IP_INTERFACE_IP_V6_ADDRESS VARCHAR(250), IP_INTERFACE_IP_V6_N OTATION_TP VARCHAR(250), IP_INTERFACE_NETMASK VARCHAR(250), IP_INTERFACE_SUBNET_ ADDRESS VARCHAR(250), IP_INTERFACE_L2_INTERFACE_NAME VARCHAR(250), LAB_RESOURCE_ INTERNAL_ID INTEGER, LAB_RESOURCE_CPU_ITEM_ID CHAR(23), LAB_RESOURCE_IP_ADDRESS VARCHAR(250), LAB_RESOURCE_MODEL VARCHAR(250), LAB_RESOURCE_MEMORY INTEGER, LAB_ RESOURCE_OWNER_ITEM_ID CHAR(23), LAB_RESOURCE_GROUP_ITEM_ID CHAR(23), LAB_RESOUR CE_NAME VARCHAR(250), LAB_RESOURCE_ADMIN_STATUS VARCHAR(250), LAB_RESOURCE_OP_ST ATUS VARCHAR(250), LAB_RESOURCE_DESCRIPTION VARCHAR(250), LAB_RESOURCE_PRIMARY_M AC_DDRSS VARCHAR(250), LAB_RESOURCE_SYSTEM_BUILD_UUID VARCHAR(250), LAB_RESOURCE _SYSTEM_ID VARCHAR(250), LAB_RESOURCE_SERIAL_NUMBER VARCHAR(250), LAB_RESOURCE_T OTAL_DISK_SIZE INTEGER, LAB_RESOURCE_FREE_DISK_SPACE INTEGER, LAB_RESOURCE_LOCAT ION VARCHAR(250), LAB_RESOURCE_MANUFACTURER VARCHAR(250), LAB_RESOURCE_MODEL_NUM BER VARCHAR(250), LAB_RESOURCE_NOTES VARCHAR(250), LAB_RESOURCE_VM_MEMORY_SIZE I NTEGER, LAB_RESOURCE_VM_DISK_SIZE INTEGER, LAB_RESOURCE_VMID VARCHAR(250), LAB_R ESOURCE_VM_STATE VARCHAR(250), LAB_RESOURCE_VM_FILE VARCHAR(250), LAB_RESOURCE_D ATE_CREATED TIMESTAMP, LAB_RESOURCE_DATE_LAST_MODIFID TIMESTAMP, LAB_RESOURCE_IM AGE_TYPE VARCHAR(250), LAB_RESOURCE_CREATED_WTH_VM_TL VARCHAR(250), LAB_RESOURCE _VERSION_ITEM_ID CHAR(23), L2_INTERFACE_MTU INTEGER, L2_INTERFACE_SPEED INTEGER, L2_INTERFACE_HW_ADDRESS VARCHAR(250), L2_INTERFACE_LOOPBACK VARCHAR(250), OPERA TING_SYSTEM_HOSTNAME VARCHAR(250), OPERATING_SYSTEM_TIME_ZONE VARCHAR(250), OPER ATING_SYSTEM_OS_TYPE VARCHAR(250), OPERATING_SYSTEM_DISTRIBUTION VARCHAR(250), O PERATING_SSTM_FLL_QLFD_DMN_NM VARCHAR(250), OPERATING_SYSTEM_KERNL_RCHTCTR VARCH AR(250), OPERATING_SYSTEM_KERNEL_VERSIN VARCHAR(250), OPERATING_SYSTEM_KERNEL_WI DTH VARCHAR(250), OPERATING_SYSTEM_MANUFACTURER VARCHAR(250), OPERATING_SYSTEM_L OCALE VARCHAR(250), OPERATING_SYSTEM_VERSION_ITM_D CHAR(23), REMOTE_CONNECTION_U RL VARCHAR(250), SOFTWARE_INSTALL_DESCRIPTION VARCHAR(250), SOFTWARE_INSTALL_DIS PLAY_NAME VARCHAR(250), SOFTWARE_INSTALL_INSTALLD_LCTN VARCHAR(250), SOFTWARE_IN STALL_MANUFACTURER VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_NAME VARCHAR(250), SOF TWARE_INSTALL_PRODUCT_ID VARCHAR(250), SOFTWARE_INSTALL_INSTALLED_DAT TIMESTAMP, SOFTWARE_INSTALL_EXECUTABLE_NM VARCHAR(250), SOFTWARE_INSTALL_VERSION_ITM_D CHA R(23), SOFTWARE_INSTALL_MA_PASSWORD VARCHAR(250), SOFTWARE_INSTALL_MA_USERNAME V ARCHAR(250), SOFTWARE_INSTALL_BFA_PATH VARCHAR(250), SOFTWARE_PATCH_INSTALL_DATE TIMESTAMP, SOFTWARE_PATCH_PATCH_ID VARCHAR(250), SOFTWARE_PATCH_VERSION_ITEM_ID CHAR(23), VERSION_BUILD_LEVEL VARCHAR(250), VERSION_LEVEL INTEGER, VERSION_MAJO R_VERSION INTEGER, VERSION_MODIFIER INTEGER, VERSION_RELEASE INTEGER, VERSION_VE RSION_STRING VARCHAR(250))
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep aring or executing statement => CREATE TABLE LM.ABSTRACT_INSTANCE(STATE_ID CHAR( 23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, FAMILY_ITEM_ID CHAR(2 3) NOT NULL, VISIBILITY BIGINT NOT NULL, JZ_DISCRIMINATOR INTEGER NOT NULL, CPU_ CPU_CORES_INSTALLED INTEGER, CPU_CPU_DIES_INSTALLED INTEGER, CPU_CPU_SPEED INTEG ER, CPU_CPU_COUNT INTEGER, CPU_CPU_MANUFACTURER VARCHAR(250), CPU_CPU_ARCHITECTU RE_WIDTH VARCHAR(250), CPU_CPU_ARCHITECTURE VARCHAR(250), IP_INTERFACE_IP_V4_ADD RESS VARCHAR(250), IP_INTERFACE_IP_V6_ADDRESS VARCHAR(250), IP_INTERFACE_IP_V6_N OTATION_TP VARCHAR(250), IP_INTERFACE_NETMASK VARCHAR(250), IP_INTERFACE_SUBNET_ ADDRESS VARCHAR(250), IP_INTERFACE_L2_INTERFACE_NAME VARCHAR(250), LAB_RESOURCE_ INTERNAL_ID INTEGER, LAB_RESOURCE_CPU_ITEM_ID CHAR(23), LAB_RESOURCE_IP_ADDRESS VARCHAR(250), LAB_RESOURCE_MODEL VARCHAR(250), LAB_RESOURCE_MEMORY INTEGER, LAB_ RESOURCE_OWNER_ITEM_ID CHAR(23), LAB_RESOURCE_GROUP_ITEM_ID CHAR(23), LAB_RESOUR CE_NAME VARCHAR(250), LAB_RESOURCE_ADMIN_STATUS VARCHAR(250), LAB_RESOURCE_OP_ST ATUS VARCHAR(250), LAB_RESOURCE_DESCRIPTION VARCHAR(250), LAB_RESOURCE_PRIMARY_M AC_DDRSS VARCHAR(250), LAB_RESOURCE_SYSTEM_BUILD_UUID VARCHAR(250), LAB_RESOURCE _SYSTEM_ID VARCHAR(250), LAB_RESOURCE_SERIAL_NUMBER VARCHAR(250), LAB_RESOURCE_T OTAL_DISK_SIZE INTEGER, LAB_RESOURCE_FREE_DISK_SPACE INTEGER, LAB_RESOURCE_LOCAT ION VARCHAR(250), LAB_RESOURCE_MANUFACTURER VARCHAR(250), LAB_RESOURCE_MODEL_NUM BER VARCHAR(250), LAB_RESOURCE_NOTES VARCHAR(250), LAB_RESOURCE_VM_MEMORY_SIZE I NTEGER, LAB_RESOURCE_VM_DISK_SIZE INTEGER, LAB_RESOURCE_VMID VARCHAR(250), LAB_R ESOURCE_VM_STATE VARCHAR(250), LAB_RESOURCE_VM_FILE VARCHAR(250), LAB_RESOURCE_D ATE_CREATED TIMESTAMP, LAB_RESOURCE_DATE_LAST_MODIFID TIMESTAMP, LAB_RESOURCE_IM AGE_TYPE VARCHAR(250), LAB_RESOURCE_CREATED_WTH_VM_TL VARCHAR(250), LAB_RESOURCE _VERSION_ITEM_ID CHAR(23), L2_INTERFACE_MTU INTEGER, L2_INTERFACE_SPEED INTEGER, L2_INTERFACE_HW_ADDRESS VARCHAR(250), L2_INTERFACE_LOOPBACK VARCHAR(250), OPERA TING_SYSTEM_HOSTNAME VARCHAR(250), OPERATING_SYSTEM_TIME_ZONE VARCHAR(250), OPER ATING_SYSTEM_OS_TYPE VARCHAR(250), OPERATING_SYSTEM_DISTRIBUTION VARCHAR(250), O PERATING_SSTM_FLL_QLFD_DMN_NM VARCHAR(250), OPERATING_SYSTEM_KERNL_RCHTCTR VARCH AR(250), OPERATING_SYSTEM_KERNEL_VERSIN VARCHAR(250), OPERATING_SYSTEM_KERNEL_WI DTH VARCHAR(250), OPERATING_SYSTEM_MANUFACTURER VARCHAR(250), OPERATING_SYSTEM_L OCALE VARCHAR(250), OPERATING_SYSTEM_VERSION_ITM_D CHAR(23), REMOTE_CONNECTION_U RL VARCHAR(250), SOFTWARE_INSTALL_DESCRIPTION VARCHAR(250), SOFTWARE_INSTALL_DIS PLAY_NAME VARCHAR(250), SOFTWARE_INSTALL_INSTALLD_LCTN VARCHAR(250), SOFTWARE_IN STALL_MANUFACTURER VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_NAME VARCHAR(250), SOF TWARE_INSTALL_PRODUCT_ID VARCHAR(250), SOFTWARE_INSTALL_INSTALLED_DAT TIMESTAMP, SOFTWARE_INSTALL_EXECUTABLE_NM VARCHAR(250), SOFTWARE_INSTALL_VERSION_ITM_D CHA R(23), SOFTWARE_INSTALL_MA_PASSWORD VARCHAR(250), SOFTWARE_INSTALL_MA_USERNAME V ARCHAR(250), SOFTWARE_INSTALL_BFA_PATH VARCHAR(250), SOFTWARE_PATCH_INSTALL_DATE TIMESTAMP, SOFTWARE_PATCH_PATCH_ID VARCHAR(250), SOFTWARE_PATCH_VERSION_ITEM_ID CHAR(23), VERSION_BUILD_LEVEL VARCHAR(250), VERSION_LEVEL INTEGER, VERSION_MAJO R_VERSION INTEGER, VERSION_MODIFIER INTEGER, VERSION_RELEASE INTEGER, VERSION_VE RSION_STRING VARCHAR(250))
CRJAZ0487I An exception occurred while creating the database schema for the package "com.ibm.rational.test.lm".
The database tables were not created.

0 votes



7 answers

Permanent link
I uninstalled DB2 V9.7 and installed V9.5.3 instead. I received the same error.

0 votes


Permanent link
Still unable to use RQM with DB2 9.5 - has anyone else had problems/success?

0 votes


Permanent link
Still unable to use RQM with DB2 9.5 - has anyone else had problems/success?


I have the same problem with RQM 2.0 and DB2 v9.1 (fixpack 4) and i've found this: http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14172582&tstart=0

c/p: Solution: When you create the Rational Quality Manager database, you must increase the default bufferpool and table page size space to 16k...

I've tried that, but then i just get different error message. Maybe it will work for you.

0 votes


Permanent link
Still unable to use RQM with DB2 9.5 - has anyone else had problems/success?


I have the same problem with RQM 2.0 and DB2 v9.1 (fixpack 4) and i've found this: http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14172582&tstart=0

c/p: Solution: When you create the Rational Quality Manager database, you must increase the default bufferpool and table page size space to 16k...

I've tried that, but then i just get different error message. Maybe it will work for you.


Eventually, after few reboot's and retry's it all worked fine.

I've created database using db2 command (on win 2k3se):

db2 create database JAZZ on c: using codeset UTF-8 territory en PAGESIZE 16384

0 votes


Permanent link
benjamin.chodroff wrote:
I have just downloaded the release version of RQM 2.0 and installed in
on SLES 11. I am also using DB2 v9.7. I tried to install RQM into DB2
by the instructions and received this error:

db-rational:/opt/IBM/RQM20/server # ./repotools.sh -createTables
Repo Tools
Rational Quality Manager, Version 2.0 (I20090713_1659)
Jazz Foundation Server, Version 1.0 (I20090618-1753)

Provisioning using "./conf/jazz/provision_profiles".
Rational Jazz Team Server (RQM) - Enterprise
CRJAZ1363I Loading configuration from
"file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location:
//localhost:50003/rqm:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/LINUX
Db Product Version: SQL09070
Db URL: jdbc:db2://localhost:50003/rqm
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
Creating the tables for the database
"//localhost:50003/rqm:user=xxxxxxxx;passwo

rd=xxxxxxxx;" with indices.
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I
Error prep
aring or executing statement
=> CREATE TABLE LM.ABSTRACT_INSTANCE(STATE_ID CHAR(

23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID
CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT
NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, FAMILY_ITEM_ID CHAR(2

3) NOT NULL, VISIBILITY BIGINT NOT NULL,
JZ_DISCRIMINATOR INTEGER NOT NULL, CPU_

CPU_CORES_INSTALLED INTEGER, CPU_CPU_DIES_INSTALLED INTEGER,
CPU_CPU_SPEED INTEG
ER, CPU_CPU_COUNT
INTEGER, CPU_CPU_MANUFACTURER VARCHAR(250), CPU_CPU_ARCHITECTU

RE_WIDTH VARCHAR(250), CPU_CPU_ARCHITECTURE
VARCHAR(250), IP_INTERFACE_IP_V4_ADD
RESS
VARCHAR(250), IP_INTERFACE_IP_V6_ADDRESS VARCHAR(250),
IP_INTERFACE_IP_V6_N
OTATION_TP
VARCHAR(250), IP_INTERFACE_NETMASK VARCHAR(250), IP_INTERFACE_SUBNET_

ADDRESS VARCHAR(250),
IP_INTERFACE_L2_INTERFACE_NAME VARCHAR(250), LAB_RESOURCE_

INTERNAL_ID INTEGER, LAB_RESOURCE_CPU_ITEM_ID CHAR(23),
LAB_RESOURCE_IP_ADDRESS
VARCHAR(250),
LAB_RESOURCE_MODEL VARCHAR(250), LAB_RESOURCE_MEMORY INTEGER, LAB_

RESOURCE_OWNER_ITEM_ID CHAR(23),
LAB_RESOURCE_GROUP_ITEM_ID CHAR(23), LAB_RESOUR

CE_NAME VARCHAR(250), LAB_RESOURCE_ADMIN_STATUS VARCHAR(250),
LAB_RESOURCE_OP_ST
ATUS VARCHAR(250),
LAB_RESOURCE_DESCRIPTION VARCHAR(250), LAB_RESOURCE_PRIMARY_M

AC_DDRSS VARCHAR(250),
LAB_RESOURCE_SYSTEM_BUILD_UUID VARCHAR(250), LAB_RESOURCE

_SYSTEM_ID VARCHAR(250), LAB_RESOURCE_SERIAL_NUMBER
VARCHAR(250), LAB_RESOURCE_T
OTAL_DISK_SIZE
INTEGER, LAB_RESOURCE_FREE_DISK_SPACE INTEGER, LAB_RESOURCE_LOCAT

ION VARCHAR(250), LAB_RESOURCE_MANUFACTURER
VARCHAR(250), LAB_RESOURCE_MODEL_NUM
BER
VARCHAR(250), LAB_RESOURCE_NOTES VARCHAR(250),
LAB_RESOURCE_VM_MEMORY_SIZE I
NTEGER,
LAB_RESOURCE_VM_DISK_SIZE INTEGER, LAB_RESOURCE_VMID VARCHAR(250),
LAB_R
ESOURCE_VM_STATE VARCHAR(250),
LAB_RESOURCE_VM_FILE VARCHAR(250), LAB_RESOURCE_D

ATE_CREATED TIMESTAMP, LAB_RESOURCE_DATE_LAST_MODIFID TIMESTAMP,
LAB_RESOURCE_IM
AGE_TYPE VARCHAR(250),
LAB_RESOURCE_CREATED_WTH_VM_TL VARCHAR(250), LAB_RESOURCE

_VERSION_ITEM_ID CHAR(23), L2_INTERFACE_MTU INTEGER,
L2_INTERFACE_SPEED INTEGER,

L2_INTERFACE_HW_ADDRESS VARCHAR(250), L2_INTERFACE_LOOPBACK
VARCHAR(250), OPERA
TING_SYSTEM_HOSTNAME
VARCHAR(250), OPERATING_SYSTEM_TIME_ZONE VARCHAR(250), OPER

ATING_SYSTEM_OS_TYPE VARCHAR(250),
OPERATING_SYSTEM_DISTRIBUTION VARCHAR(250), O

PERATING_SSTM_FLL_QLFD_DMN_NM VARCHAR(250),
OPERATING_SYSTEM_KERNL_RCHTCTR VARCH

AR(250), OPERATING_SYSTEM_KERNEL_VERSIN VARCHAR(250),
OPERATING_SYSTEM_KERNEL_WI
DTH
VARCHAR(250), OPERATING_SYSTEM_MANUFACTURER VARCHAR(250),
OPERATING_SYSTEM_L
OCALE VARCHAR(250),
OPERATING_SYSTEM_VERSION_ITM_D CHAR(23), REMOTE_CONNECTION_U

RL VARCHAR(250), SOFTWARE_INSTALL_DESCRIPTION
VARCHAR(250), SOFTWARE_INSTALL_DIS

PLAY_NAME VARCHAR(250), SOFTWARE_INSTALL_INSTALLD_LCTN VARCHAR(250),
SOFTWARE_IN
STALL_MANUFACTURER
VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_NAME VARCHAR(250), SOF

TWARE_INSTALL_PRODUCT_ID VARCHAR(250),
SOFTWARE_INSTALL_INSTALLED_DAT TIMESTAMP,

SOFTWARE_INSTALL_EXECUTABLE_NM VARCHAR(250),
SOFTWARE_INSTALL_VERSION_ITM_D CHA
R(23),
SOFTWARE_INSTALL_MA_PASSWORD VARCHAR(250),
SOFTWARE_INSTALL_MA_USERNAME V
ARCHAR(250),
SOFTWARE_INSTALL_BFA_PATH VARCHAR(250), SOFTWARE_PATCH_INSTALL_DATE

TIMESTAMP, SOFTWARE_PATCH_PATCH_ID
VARCHAR(250), SOFTWARE_PATCH_VERSION_ITEM_ID

CHAR(23), VERSION_BUILD_LEVEL VARCHAR(250), VERSION_LEVEL INTEGER,
VERSION_MAJO
R_VERSION INTEGER,
VERSION_MODIFIER INTEGER, VERSION_RELEASE INTEGER, VERSION_VE

RSION_STRING VARCHAR(250))
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I
Error prep
aring or executing statement
=> CREATE TABLE LM.ABSTRACT_INSTANCE(STATE_ID CHAR(

23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID
CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT
NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, FAMILY_ITEM_ID CHAR(2

3) NOT NULL, VISIBILITY BIGINT NOT NULL,
JZ_DISCRIMINATOR INTEGER NOT NULL, CPU_

CPU_CORES_INSTALLED INTEGER, CPU_CPU_DIES_INSTALLED INTEGER,
CPU_CPU_SPEED INTEG
ER, CPU_CPU_COUNT
INTEGER, CPU_CPU_MANUFACTURER VARCHAR(250), CPU_CPU_ARCHITECTU

RE_WIDTH VARCHAR(250), CPU_CPU_ARCHITECTURE
VARCHAR(250), IP_INTERFACE_IP_V4_ADD
RESS
VARCHAR(250), IP_INTERFACE_IP_V6_ADDRESS VARCHAR(250),
IP_INTERFACE_IP_V6_N
OTATION_TP
VARCHAR(250), IP_INTERFACE_NETMASK VARCHAR(250), IP_INTERFACE_SUBNET_

ADDRESS VARCHAR(250),
IP_INTERFACE_L2_INTERFACE_NAME VARCHAR(250), LAB_RESOURCE_

INTERNAL_ID INTEGER, LAB_RESOURCE_CPU_ITEM_ID CHAR(23),
LAB_RESOURCE_IP_ADDRESS
VARCHAR(250),
LAB_RESOURCE_MODEL VARCHAR(250), LAB_RESOURCE_MEMORY INTEGER, LAB_

RESOURCE_OWNER_ITEM_ID CHAR(23),
LAB_RESOURCE_GROUP_ITEM_ID CHAR(23), LAB_RESOUR

CE_NAME VARCHAR(250), LAB_RESOURCE_ADMIN_STATUS VARCHAR(250),
LAB_RESOURCE_OP_ST
ATUS VARCHAR(250),
LAB_RESOURCE_DESCRIPTION VARCHAR(250), LAB_RESOURCE_PRIMARY_M

AC_DDRSS VARCHAR(250),
LAB_RESOURCE_SYSTEM_BUILD_UUID VARCHAR(250), LAB_RESOURCE

_SYSTEM_ID VARCHAR(250), LAB_RESOURCE_SERIAL_NUMBER
VARCHAR(250), LAB_RESOURCE_T
OTAL_DISK_SIZE
INTEGER, LAB_RESOURCE_FREE_DISK_SPACE INTEGER, LAB_RESOURCE_LOCAT

ION VARCHAR(250), LAB_RESOURCE_MANUFACTURER
VARCHAR(250), LAB_RESOURCE_MODEL_NUM
BER
VARCHAR(250), LAB_RESOURCE_NOTES VARCHAR(250),
LAB_RESOURCE_VM_MEMORY_SIZE I
NTEGER,
LAB_RESOURCE_VM_DISK_SIZE INTEGER, LAB_RESOURCE_VMID VARCHAR(250),
LAB_R
ESOURCE_VM_STATE VARCHAR(250),
LAB_RESOURCE_VM_FILE VARCHAR(250), LAB_RESOURCE_D

ATE_CREATED TIMESTAMP, LAB_RESOURCE_DATE_LAST_MODIFID TIMESTAMP,
LAB_RESOURCE_IM
AGE_TYPE VARCHAR(250),
LAB_RESOURCE_CREATED_WTH_VM_TL VARCHAR(250), LAB_RESOURCE

_VERSION_ITEM_ID CHAR(23), L2_INTERFACE_MTU INTEGER,
L2_INTERFACE_SPEED INTEGER,

L2_INTERFACE_HW_ADDRESS VARCHAR(250), L2_INTERFACE_LOOPBACK
VARCHAR(250), OPERA
TING_SYSTEM_HOSTNAME
VARCHAR(250), OPERATING_SYSTEM_TIME_ZONE VARCHAR(250), OPER

ATING_SYSTEM_OS_TYPE VARCHAR(250),
OPERATING_SYSTEM_DISTRIBUTION VARCHAR(250), O

PERATING_SSTM_FLL_QLFD_DMN_NM VARCHAR(250),
OPERATING_SYSTEM_KERNL_RCHTCTR VARCH

AR(250), OPERATING_SYSTEM_KERNEL_VERSIN VARCHAR(250),
OPERATING_SYSTEM_KERNEL_WI
DTH
VARCHAR(250), OPERATING_SYSTEM_MANUFACTURER VARCHAR(250),
OPERATING_SYSTEM_L
OCALE VARCHAR(250),
OPERATING_SYSTEM_VERSION_ITM_D CHAR(23), REMOTE_CONNECTION_U

RL VARCHAR(250), SOFTWARE_INSTALL_DESCRIPTION
VARCHAR(250), SOFTWARE_INSTALL_DIS

PLAY_NAME VARCHAR(250), SOFTWARE_INSTALL_INSTALLD_LCTN VARCHAR(250),
SOFTWARE_IN
STALL_MANUFACTURER
VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_NAME VARCHAR(250), SOF

TWARE_INSTALL_PRODUCT_ID VARCHAR(250),
SOFTWARE_INSTALL_INSTALLED_DAT TIMESTAMP,

SOFTWARE_INSTALL_EXECUTABLE_NM VARCHAR(250),
SOFTWARE_INSTALL_VERSION_ITM_D CHA
R(23),
SOFTWARE_INSTALL_MA_PASSWORD VARCHAR(250),
SOFTWARE_INSTALL_MA_USERNAME V
ARCHAR(250),
SOFTWARE_INSTALL_BFA_PATH VARCHAR(250), SOFTWARE_PATCH_INSTALL_DATE

TIMESTAMP, SOFTWARE_PATCH_PATCH_ID
VARCHAR(250), SOFTWARE_PATCH_VERSION_ITEM_ID

CHAR(23), VERSION_BUILD_LEVEL VARCHAR(250), VERSION_LEVEL INTEGER,
VERSION_MAJO
R_VERSION INTEGER,
VERSION_MODIFIER INTEGER, VERSION_RELEASE INTEGER, VERSION_VE

RSION_STRING VARCHAR(250))
CRJAZ0487I An exception occurred while creating the database schema
for the package "com.ibm.rational.test.lm".
The database tables were not created.

Have you looked at the DB2 diag.log, it will probably suggest what is

going on? By the way this is how I created my database:

db2 create database rqm20 using codeset utf-8 territory us collate using
system pagesize 16384 with 'RQM20 Database' autoconfigure using
mem_percent 40 apply db only

db2 update db cfg for rqm20 using dbheap 4096
db2 update db cfg for rqm20 using logretain on
db2 update db cfg for rqm20 using trackmod on

0 votes


Permanent link
Thanks, this worked for me (slightly different):

su - db2inst1
db2 create database rqm20 using codeset utf-8 territory us collate using system pagesize 16384 autoconfigure using mem_percent 40 apply db only

db2 update db cfg for rqm20 using dbheap 4096
db2 update db cfg for rqm20 using logretain on
db2 update db cfg for rqm20 using trackmod on

Thanks!

0 votes


Permanent link
benjamin.chodroff wrote:
Thanks, this worked for me (slightly different):

su - db2inst1
db2 create database rqm20 using codeset utf-8 territory us collate
using system pagesize 16384 autoconfigure using mem_percent 40 apply
db only

db2 update db cfg for rqm20 using dbheap 4096
db2 update db cfg for rqm20 using logretain on
db2 update db cfg for rqm20 using trackmod on

Thanks!

Yes - I left out the su - db2inst1 - I had assumed you logged in as the

db2 administrator. BTW the last 2 lines allows you to do full online
and incremental backups of the database so you can keep the rqm server
up all the time. We have used this for several months now to keep or
data backed up.

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: Jul 29 '09, 12:18 p.m.

Question was seen: 11,305 times

Last updated: Jul 29 '09, 12:18 p.m.

Confirmation Cancel Confirm