Creating a database for the Sametime Bandwidth Manager

Create a 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.

Procedure

Complete the following steps to create the Bandwidth Manager database.

  1. On the DB2 server, log in as the DB2 administrator.
  2. Start the DB2 command line window by running the following command:
    • AIX® or 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 COLLATE USING UCA400_NO 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.

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

  4. Verify that the new database was created 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.

  5. Close the DB2 command window.