Jazz Team Server (RTC 1.0.1) with DB2 (no express)
I am installing the Jazz Team Server (RTC 1.0.1) on a Windows 2003 Server 32 Bits and I have a doubt. Anybody got the script to create the tables on DB2? I would check it before, because it will be used in a shared instance.
|
5 answers
Using RTC 1.0.1 on a Windows 2003 machine should be no problem. If you
want to create the tables, you can use the 'repotools -createTables' command. - Matt Lavin Jazz Server Team On Fri, 2008-12-12 at 19:37 +0000, rodsilva wrote: I am installing the Jazz Team Server (RTC 1.0.1) on a Windows 2003 |
|
|
|
When you run the tool it automatically creates the tables for you.
- Matt Lavin Jazz Server Team On Mon, 2008-12-15 at 14:08 +0000, rodsilva wrote: I see the script before creating the table? |
|
I would check all the commands that are executed when you use repotools-createtables
this is the script for db2 of Rational Build Forge, I need an equal for Team Concert, not found in any documentation "// Criar banco de dados db2 CREATE DATABASE BFT ALIAS BUILD AUTOCONFIGURE USING MEM_PERCENT 40 APPLY DB ONLY USING CODESET UTF-8 TERRITORY US db2 CONNECT TO BUILD db2 CREATE BUFFERPOOL "BUFFP1" IMMEDIATE SIZE 1000 PAGESIZE 8192 NOT EXTENDED STORAGE; db2 CONNECT RESET; db2 CONNECT TO BUILD; // Criar espaos de tabela db2 CREATE SYSTEM TEMPORARY TABLESPACE TEMPSPACE2 PAGESIZE 8192 MANAGED BY SYSTEM USING ('<caminho_para_banco_de_dados>/SQL003.0') EXTENTSIZE 64 PREFETCHSIZE 64 BUFFERPOOL BUFFP1; db2 CREATE USER TEMPORARY TABLESPACE BFUSE_TEMP PAGESIZE 8192 MANAGED BY SYSTEM USING ('<caminho_para_banco_de_dados>/SQL004.0') EXTENTSIZE 64 PREFETCHSIZE 64 BUFFERPOOL BUFFP1; db2 CREATE REGULAR TABLESPACE USERSPACE2 PAGESIZE 8192 MANAGED BY SYSTEM USING ('<caminho_para_banco_de_dados>/SQL005.0') EXTENTSIZE 64 PREFETCHSIZE 64 BUFFERPOOL BUFFP1; // O usurio deve receber a autorizao de utilizao do espao de tabela BFUSE_TEMP db2 GRANT USE OF TABLESPACE BFUSE_TEMP TO USER BUILD WITH GRANT OPTION db2 commit work; db2 CONNECT RESET; db2 terminate; " |
|
Ah, it is probably possible to generate something like that if you
adjust some log settings. Can you explain why you would want to look at all of the commands listed? Considering our table structure is internal, it doesn't seem very useful to look at the creation commands. - Matt Lavin Jazz Server Team On Mon, 2008-12-15 at 16:17 +0000, rodsilva wrote: I would check all the commands that are executed when you use |
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.