error:RQM 2.0.1 repotools.sh -createTables using DB2 V9.7 CE

Technically it looks like DB2 V9.7 is not officially supported on 32 bit Linux, BUT it seems like your problem is not changing the default page size to 16K, per: http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_db2.html

Regards,
John Nason

Has anyone got detailed knowledge of
RQM install on RedHat Linux 5.4 with DB2 V9.7?

Log files were captured. Let me know if I should file a defect.

I installed DB2 V9.7 Community Edition
also RQM 2.0.1 on Redhat Linux

I ran repotools.sh -createTables which MOSTLY succeeded.
The tool reported error:

com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE TABLE LM.ABSTRACT_INSTANCE(STATE_ID CHAR(23)...
...
Caused by:
com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;DB2INST1, DRIVER=3.53.70

Thanks, you are absolutely correct. Although I read that doc page, I messed up and selected 8K page size. Will have a go today! Assuming it works, I'm potentially going to get my 1st DB2-based JAZZ product running!!!

Technically it looks like DB2 V9.7 is not officially supported on 32 bit Linux, BUT it seems like your problem is not changing the default page size to 16K, per: http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_db2.html

Regards,
John Nason

Has anyone got detailed knowledge of
RQM install on RedHat Linux 5.4 with DB2 V9.7?

Log files were captured. Let me know if I should file a defect.

I installed DB2 V9.7 Community Edition
also RQM 2.0.1 on Redhat Linux

I ran repotools.sh -createTables which MOSTLY succeeded.
The tool reported error:

com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE TABLE LM.ABSTRACT_INSTANCE(STATE_ID CHAR(23)...
...
Caused by:
com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;DB2INST1, DRIVER=3.53.70

The repotools.sh -createTables failed on:
CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file '/var/opt/jazzdb2/db2inst1/content_tablespace' 250000) DROPPED TABLE RECOVERY OFF AUTORESIZE YES
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-968, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.53.70
SQL State: 57011
Error Code: -968

That's not a typo, on "CONTENTTS" right? The double TT are supposed to be in there?

Got into the "db2" command and ran that CREATE Database ... command by hand. I finally got a useful piece of info that way - the disk got full! Proceeding to add more.

Eureka! I got the DB2 content_tablespace created and the repotools.sh -createTables worked.
The teamserver.properties notes to create the tablespace in 4Kbyte page sizes and has a suggestion of 25000 pages for a size of 1 Gbyte. However, I created the database using a 16Kbytes buffer size.

The resulting content_tablespace file ended up being exactly 4Gbytes.

I added a separate 5 Gbyte disk to the VMWARE image and watched the free space shrink down to 663 Mbytes free before that content_tablespace file was finished.

Anyhow, moving on now.