Creating database schemas

When configuring the IMS Server, you can choose your own database schema or have the configuration wizard create the database schema. If you want to use your own database schema, run the correct SQL scripts for your supported database server.

• If you want to use your own database schema, create the database schema before you start the configuration of the IMS Server data source and certificate.
• The delimiter for:
  • IBM® DB2®: initPL.sql script is !.
  • Oracle: initPL.sql and logPL.sql scripts, is /.
  • All databases: the delimiter is ;.

If IBM DB2 Server is the IMS Server database:

1. Browse to <IMS Server installation directory>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\db2\create-schema.
2. Run these scripts in the following order:
   1. init.sql
   2. log.sql
   3. initPL.sql
3. Browse to <IMS Server installation directory>\com.ibm.tamesso.ims-delhi.build.root\src\database\data\sql\common\initialize-prod.
4. Run boot.sql.
5. Browse to <IMS Server installation directory>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\db2\create-schema.
6. Run view.sql.

If Microsoft SQL Server is the IMS Server database:

1. Log on to SQL Server Management Studio. For example: imsdbusr
   Important: Specify the SQL Server logon account that you created in 4 on Creating the database in SQL Server manually.
2. Complete the following steps for each of the scripts:

   Run each of the following SQL scripts in order:

   Do:

   <ims_home>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\sqlserver\create-schema\init.sql <ims_home>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\sqlserver\create-schema\log.sql <ims_home>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\common\initialize-prod\boot.sql <ims_home>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\sqlserver\create-schema\view.sql

   To run the SQL script: Open the SQL script. Click the Query Options command. Set the batch separator to ";", without the quotes. Click OK. Click Execute.

3. Verify the tables:
   1. Expand <IMS Server database_name> > Tables.
   2. Ensure that the table names include the SQL Server logon name as a prefix. For example: imsdbusr.<table name>

If Oracle Database is the IMS Server database:

1. Browse to <IMS Server installation directory>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\oracle\create-schema.
2. Run these scripts in the following order:
   1. init.sql
   2. log.sql
   3. initPL.sql
   4. logPL.sql
3. Browse to <IMS Server installation directory>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\common\initialize-prod.
4. Run boot.sql.
5. Browse to <IMS Server installation directory>\com.ibm.tamesso.ims-delhi.build.boot\src\database\data\sql\oracle\create-schema.
6. Run view.sql.