Deploying and configuring the enterprise database

Although it is possible to deploy the server together with Domino® and IBM Traveler, it is not recommended. DB2® or SQL should be deployed on its own server, and the server should be a 64-bit system.

There are two options for configuring your enterprise database. The first option is the 'autoschema' method. For this option you will create a Database and a User, and then IBM Traveler will create, alter, and manage the Enterprise Database Schema. This can be considered the 'hands-off' approach. The second option is to manually create and handle the Database Schema using the supplied DDLs. This second option allows you to specifically customize the database to your needs or requirements.

• Configure DB2 for IBM Traveler using the DB2 Configuration Wizard
• Configure DB2 for IBM Traveler using DDL
• Configure SQL for IBM Traveler using the SQL Server Management Studio
• Configure SQL for IBM Traveler using DDL

To configure DB2® using the DB2® Configuration Wizard, perform the following procedure:

1. Launch the DB2® Control Center by selecting Create Database > Standard.

2. In the Create Database Wizard, select the defaults for each attribute unless otherwise noted. Fill in the Database name.

3. Change the Code Set dialog box to UTF-8.

4. Click through the rest of the wizard and select Finish to create the IBM Traveler database.
   Note: After IBM Traveler is configured for DB2®, it will automatically create the required database schema, tables, and so on.

To configure DB2® using DDL, perform the following procedure:

1. Unzip the IBM Traveler DDL in <domino install data dir>\traveler\cfg\db\TravelerSQL.zip or TravelerSQL.tar.gz to the directory <sqldir> cd <sqldir>/SQLSERVER.
2. Make any updates necessary, for example the location of files, sizes of the database, schema names, and so on.
3. For Windows™, create the DB Login user, IBM Traveler DB and DB objects, using the following command:

   db2cmd -c -w -i db2 -tvf createDb.sql 

   For Linux™:

   su - db2inst1 
   db2 -tvf createDb.sql 

4. For Windows™, grant the necessary permissions to the DB Login user to the IBM Traveler DB, using the following command.

    db2cmd -c -w -i db2 -tvf appGrants.sql 

   For Linux™:

   db2 -tvf appGrants.sql 

5. Create an Operating System User that matches the DB2® user specified in the appGrants.sql file.
6. Update the notes.ini to add the following property to tell the system the IBM Traveler DB and its objects were created:

   NTS_AUTO_DBSCHEMA=false 

   If you changed the schema name in the DDL files, you must set the following property in the notes.ini, where <schemaname> is the schema name used in the DDL files:

   NTS_DB2_SCHEMA=<schemaname>

To configure SQL for IBM Traveler using the SQL Server Management Studio, perform the following procedure:

1. Launch the SQL Server Management Studio and log in as an Admin user.
2. Create a database user by right clicking Login from Security. Then select New Login.
3. Enter a name and password for the user, set the password policies to your company's requirements, and keep the remaining settings as defaults.
4. Click OK to create the profile.
5. Create the database using the database wizard. Right click Database, then select New Database.
6. Fill in the information in the wizard, selecting the defaults unless otherwise instructed. Enter a database name, then enter the new user name you created previously as the owner of the database.

   The recommended collation setting is Latin1_General_BIN.

7. Click OK to create the database with these settings.

To configure SQL using DDL, perform the following procedure:

1. Unzip the IBM Traveler DDL in <domino install data dir>\traveler\cfg\db\TravelerSQL.zip or TravelerSQL.tar.gz to the directory <sqldir> cd <sqldir>/SQLSERVER.
2. Make any updates necessary, for example the location of files, sizes of the database, schema names, and so on.
3. Create the DB Login user, IBM Traveler DB and DB objects.

   sqlcmd -U <admin_user> -P <admin_password> -i "createDb.sql" -v 
   filepath="<path_to_db>" password="<password to use for traveler d
   db user>"  

4. Grant the necessary permissions to the DB Login user to the IBM Traveler DB.

    sqlcmd -U <admin_user> -P <admin_password> -i "appGrants.sql"

5. Update the notes.ini to add the following property to tell the system the IBM Traveler DB and its objects were created:

   NTS_AUTO_DBSCHEMA=false