Creating a database for the Sametime Bandwidth Manager

Create an IBM® DB2® database to store information for the IBM Sametime® Bandwidth Manager.

Before you begin

You can create the database on the DB2 server that you installed for use with the Sametime System Console, or on any DB2 server that meets the Sametime system requirements. The DB2 server must be running when you create the Bandwidth Manager database.

About this task

The DB2 server has a local system administration account, db2admin. When you connect to the DB2 server, be sure to use the local db2admin account or commands may not work as expected.

Procedure

Complete the following steps to create the Bandwidth Manager database.
  1. On the DB2 server, log in as the DB2 administrator. (Use a db2admin account name and password with access to create databases.)
  2. Start the DB2 command line window by running the following command:
    • Linux™: db2
    • Windows™: db2cmd
  3. Run the following command to create the Bandwidth Manager database:
    CREATE DATABASE "Database_name" AUTOMATIC STORAGE YES ALIAS Database_name USING codeset UTF-8 territory US_PAGESIZE 8 K

    where Database_name is the name of the database you are creating. The database name must correspond to the name that you supply for the db2.connection.database property in the db2.connection.properties file before installing the Bandwidth Manager application. Examples in this documentation use "BWM_DATA" as the database name.

    For example, enter CREATE DATABASE "BWM_DATA" AUTOMATIC STORAGE YES ALIAS BWM_DATA USING codeset UTF-8 territory US_PAGESIZE 8 K

    When naming DB2 objects, follow the rules for your operating system.

    Note: The database creation can take a few minutes. Do not close the window if the database creation process seems be non-responsive.
  4. Verify that you see the message The CREATE DATABASE command completed successfully.
  5. Verify that you can connect to the new database by entering the following command:

    db2 connect to BWM_DATA

    where BWM_DATA represents the name of the database you created. Verify that you can connect to the database.

  6. From the DB2 command window, run the following configuration updates, then close the DB2 command window.

    db2 update db cfg for BWM_DATA using LOGFILSIZ 1000

    db2 update db cfg for BWM_DATA using logprimary 10 logsecond 235