Developing SIP and IP Multimedia Subsystem (IMS) Applications

Appendix B. Installing the sample application test environment 589

6. Click Apply.

7. Click Save changes to the master configuration.

B.3.3 Configure DB2

GLS utilizes database tables to store usage records. The process described in

this section is for configuring and creating DB2 databases.

DB2 databases and tables are created using the script crtsrvDb2.sh. The script

requires several parameters that modify the behavior.

Table B-3 GLM610D script arguments

Note: It is assumed that DB2 8.2 with fix pack 4 has been installed.

Argument Description

Database server hostname This value must be the hostname and domain (for

example machine1.ibm.com)

Note: Localhost should not be used even if the

database is hosted locally.

Database server connection port This value is normally 50000

Database name This can be any valued DB2 database name,

however GLM610D was used for this example

Database alias This can be any valued DB2 database alias,

however GLM610D was used for this example

Database locale For this sample test environment, this value was

set to US

Database server instance id In this example, this value was set to db2inst1

Database server instance

password

Database user ID In this example, the user ID was set to db2inst1

Database user ID password

Path and file name of DDL file This value will change depending on the request

that is being made

New database directory This is the file system directory to host the

database. In the example this will be

/home/db2inst1/glsdb

590 Developing SIP and IP Multimedia Subsystem (IMS) Applications

1. Login to the DB2 server as an administrator.

2. Enter the following command: su - db2inst1

Where, db2inst1 is the DB2 username.

3. Create a new directory to host the database.

mkdir /home/db2inst1/glsdb

4. Change directory to the location of ctrsrvDb2.sh.

cd /opt/IBM/WebSphere/GroupListServer/Database_Setup/DB2

5. Execute the following command.

./crtsrvDb2.sh

6. Enter the path and filename of the UsageDbDb2.ddl when prompted.

7. A numbered list of parameters will appear.

a. Enter the number of any value you want to change.

b. Press Enter.

c. Enter the new value according to recommendations in Table B-3 on

page 589.

d. Press Enter.

Figure B-32 on page 591 shows the values that were used for the sample test

environment described in this redbook.

Database (re)create This determines if the script will drop the database,

and recreate at the beginning of the script.

Argument Description