Updating the db2.connection.properties file for the stand-alone Bandwidth Manager

This procedure prepares a Sametime® Bandwidth Manager Server for a stand-alone installation. If you anticipate expanding the Bandwidth Manager deployment to support high availability, skip this section and follow the instructions to install a cluster of Bandwidth Manager Servers.

About this task

Update the db2.connection.properties file included in the IBM® Sametime Bandwidth Manager installation package to add settings for your deployment. The db2.connection.properties file is used during installation to create a new connection to the Bandwidth Manager database hosted on the deployment's IBM DB2® server. Update the file and specify settings for your deployment as explained here.

Procedure

On the computer where you will install the Bandwidth Manager, log on as root (Linux) or as the system administrator (Windows).
Find the software packages you need to download.
Download the packages.
Extract all downloaded packages.
Navigate to the folder containing the extracted installation files.
Update the db2.connection.properties file as follows:
1. Change the properties of the db2.connection.properties file to make it editable if necessary.
  This file was supplied with the Bandwidth Manager installation package and may be set to read-only.
2. Open the db2.connection.properties file for editing and change the following lines:
```
db2.login=DB2Username
db2.password=DB2Password 
db2.connection.address=HostName 
db2.connection.port=50000 or other DB2 port 
db2.schema=SCHEMANAME typically the DB2USERNAME
db2.connection.database=Database_name, that is, BWM_DATA
```
  where:
  - DB2Username and DB2Password are the credentials of the user who created the BWM_DATA database (usually the DB2 instance owner).
  - HostName can be a short name, fully qualified domain name, or an IP address as long as it is addressable by both the install program and the Bandwidth Manager runtime. A fully qualified domain name is recommended. You can use a short name if it is defined in the local hosts file, for example system32\driver\etc\hosts on Windows or /etc/hosts on Linux.
  - DB2Port is the DB2 server network port. The default is 50000, but change this to the appropriate value if your DB2 server uses a different port.
  - SchemaName is the name of the database schema used by the Bandwidth Manager. Typically the default database schema is used, which is named the same as the DB2USERNAME, but the schema must be in uppercase letters. On Linux, the schema name is case sensitive.
  - Database_nme must be the same value that you used when you created the Bandwidth Manager database. The examples in this documentation use "BWM_DATA" as the database name.
  For example:
```
db2.login=myDB2user
db2.password=myDB2passw0rd 
db2.connection.address=db2svr.example.com 
db2.connection.port=50000 
db2.schema=MYDB2USER 
db2.connection.database=BWM_DATA 
```
3. Save and close the file.