Initializing a DB2 Database

The following topic describes how to configure TrackStudio for use with a DB2 database management system.

Create user tablespace and temp system tablespace.
Open a DB2 command window (Windows) or log into the server (UNIX).
Connect to the database:

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

Configure the database connection properties:
- TrackStudio SA: Go to the Database -> Database Connectivity tab, and enter the JDBC connection properties.
- TrackStudio WAR: Edit the trackstudio.hibernate.properties:

Copy Code

hibernate.dialect org.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

Initialize the database:
- TrackStudio SA: Go to the Database -> Database Management tab and click the Create Database button.
- TrackStudio WAR: Execute sql\install\trackstudio-db2.sql:

Copy Code

> db2 -tvf trackstudio-db2.sql

Topic path: Installation Guide > Creating and Managing the Database > Initializing a DB2 Database