Setting up an SQL Server database

To set up a SQL Server database to use with Design Management Server, you can either use the command line or a visual tool such as SQL Server Studio Management.

Before you begin

Procedure

The following instructions assume that you are using the sqlcmd tool, but you can also use the SQL Server Management Studio.

  1. On the database server, while logged in as a database administrator, open a command prompt window and run the sqlcmd command to connect to the database. For example, you can run this command:
    sqlcmd -S localhost\instanceName
    Use the name of the database instance for instanceName.
  2. While connected to the database, run the following commands to create a database and user for the Jazz Team Server application:
    CREATE DATABASE JTS
    GO
    CREATE LOGIN jtsDBuser
    WITH PASSWORD = 'jtsDBpw';
    USE JTS;
    exec sp_changedbowner 'jtsDBuser'
    GO 
  3. Run the following command to change the collation setting for the database:
    ALTER DATABASE JTS COLLATE SQL_Latin1_General_CP437_CS_AS
    GO
  4. Run the following command to change the row version system for the database:
    ALTER DATABASE JTS SET READ_COMMITTED_SNAPSHOT ON
    GO
  5. Similarly, configure 3 additional databases for Design Management Server (DM), the data warehouse (DW) and Configuration Management Server (VVC) substituting the <DB_name> for the names of the databases (DM, DW, and VVC).
    1. Create the database and user:
      CREATE DATABASE <DB_name> 
      GO 
      CREATE LOGIN <DB_name>DBuser
      WITH PASSWORD = '<DB_name>DBpw';
      USE <DB_name>;
      exec sp_changedbowner '<DB_name>DBuser'
      GO 
    2. Change the collation setting:
      ALTER DATABASE <DB_name> COLLATE SQL_Latin1_General_CP437_CS_AS 
      GO
    3. Change the row version system:
      ALTER DATABASE <DB_name> SET READ_COMMITTED_SNAPSHOT ON
      GO
  6. Close the database connection with the command exit.
  7. If you are connecting to your SQL Server database using WebSphere® Application Server with JRE 5.0 or the version of Tomcat that is included with theDesign Management Server , set the SQLSERVER_JDBC_DRIVER_FILE system variable on the Design Management Server to point to the JRE 5.0 version of the JDBC driver named sqljdbc.jar.
    Note: Do not use spaces in file paths to the JDBC driver. For the Program Files directory on 32-bit systems, you can use PROGRA~1. For the Program Files (x86) directory on 64-bit systems, you can use PROGRA~2.
  8. If you are connecting to the SQL Server database using WebSphere Application Server with JRE 6.0 or if you want to configure your Tomcat server to use Java Runtime Environment 6.0, perform the following steps:
    1. Set the SQLSERVER_JDBC_DRIVER_FILE system variable to point to the JRE 6.0 version of the JDBC driver named sqljdbc4.jar.
    2. Specify the location of the JRE in the following files:
      For Windows
      • installDir/server/repotools-jts.bat
      • installDir/internal/repotools/repotools.bat
      For Linux
      • installDir/server/repotools-jts.sh
      • installDir/internal/repotools/repotools.sh
      Each of these files defines a variable named JAVA, as in the following example:
      if [ `uname` = Darwin ];
        then
          JAVA="/usr/bin/java"
          VMARGS="$VMARGS -XX:MaxPermSize=384m"
          DEFINE="$DEFINE -Dcom.ibm.team.repotools.rcp.allowInvalidBundles=true"
        else
          JAVA="$START_DIR/jre/bin/java"
      fi
      Change each assignment statement for this variable to the location of the JRE. The resulting code looks like this, with your JRE location in place of jreLocation:
      if [ `uname` = Darwin ];
        then
          JAVA="jreLocation/bin/java"
          VMARGS="$VMARGS -XX:MaxPermSize=384m"
          DEFINE="$DEFINE -Dcom.ibm.team.repotools.rcp.allowInvalidBundles=true"
        else
          JAVA="jreLocation/bin/java"
      fi
    3. Save and close the files.

What to do next

If you use the Design Management Server setup wizard to configure the server, no further database customization is necessary. This setup wizard configures the databases and creates the necessary tables.

If you are not running the setup wizard, you can customize the databases manually; for information, see Setting up an SQL Server database in the Rational® Team Concert installation documentation.


Feedback