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.
- On the DB2 server,
log in as the DB2 administrator.
(Use a db2admin account name and password with access to create databases.)
- Start the DB2 command
line window by running the following command:
- Linux™:
db2
- Windows™:
db2cmd
- 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.
- Verify that you see the message The CREATE DATABASE
command completed successfully.
- 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.
- 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