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.
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.
7 answers
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:
I've tried that, but then i just get different error message. Maybe it will work for you.
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:
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):
benjamin.chodroff wrote:
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
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
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!
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!
benjamin.chodroff wrote:
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.
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.