TrackStudio Enterprise 3.1
Up | Next
Initializing DB2 Database

This section describes how to configure DB2 database.

1. Create user tablespace and temp system tablespace. 

2. Open a DB2 command window (DOS prompt) (Windows) or log into the server (UNIX) 

3. Connect to the database

> db2 connect to <databasename> user <dbuser> using <password>

4.Configure the database connection properties:

  • TrackStudio SA: Go to the Database Connectivity tab, enter the JDBC connection properties.
  • TrackStudio WAR: Edit the trackstudio.hibernate.properties:
hibernate.dialect net.sf.hibernate.dialect.DB2Dialect
hibernate.connection.url jdbc:db2://127.0.0.1/trackstudio
hibernate.connection.driver_class COM.ibm.db2.jdbc.net.DB2Driver
hibernate.connection.username db2admin
hibernate.connection.password db2admin

5. Initialize the database:

  • TrackStudio SA: Go to the Database Management tab and click the Create Database button.
  • TrackStudio WAR: Execute sql\en\trackstudio-db2.sql:
> db2 -tvf trackstudio-db2.sql
Copyright (c) 2002-2005. All rights reserved.