Creating the Jazz Team Server database tables

Create the database tables using the repository tools.
To create the database tables:
  1. Review and update the database location in the teamserver.properties file:
    com.ibm.team.repository.db.vendor = DB2
    
    com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;
    user=db2admin;password={password};
    
    com.ibm.team.repository.db.jdbc.password=db2admin
  2. Log on with db2inst1 or your DB2® instance user name.
  3. Run the command repotools.sh -createTables to create the database tables for a Jazz™ repository.

    The repotools file is located in JazzInstallDir/server.

    The command uses the configuration properties in teamserver.properties for the connection and size settings. By default, the command looks in the current directory. The parameter teamserver.properties can be used to reference a different properties file.

    • If you are running a 32-bit system, edit repotools.sh and replace zLinux64/ibm-java2-s390x-50 with zLinux32/ibm-java2-s390-50.
    • Execute the following command:
      ./repotools.sh -createTables
    This command creates the tablespace and all the required tables and indexes for a Jazz Team Server repository.
  4. After the database tables are created, you must stop and restart the database to make sure all changes are in effect.
    Tip: Example commands that stop and start DB2 are db2stop and db2start.
You are finished setting up your database and can continue with Starting the server.

Feedback

Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug