Deploying and configuring the enterprise database

This section contains instructions for deploying and configuring both DB2® and SQL enterprise databases for IBM Traveler.

Install the Server

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.
Note: For improved performance, using Solid State Drive technology with the database server is recommended. For additional information, see Capacity planning guidelines for IBM Traveler
Note: Ensure you are using the latest available supported version of your database technology. To see a complete list of supported database products see the detailed system requirements.
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

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.

Configure DB2® for IBM Traveler using DDL

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>

Configure SQL for IBM Traveler using the SQL Server Management Studio

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.

Configure SQL for IBM Traveler using DDL

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