WebSphere brand IBM WebSphere Telecom Web Services Server, Version 7.1

Creating and configuring the DB2 database server instance

If you are using a DB2® database, you must create and configure the database server instance. After you perform this task, you will run the First Steps script to create the necessary database tables and complete your configuration.

Before you begin
Before you begin, you must have completed the following tasks:
  • Installed and started IBM® DB2 Enterprise Server Edition, version 9.5.0.4 or 9.7.0.1
  • Performed the database configuration steps in the topic Preparing to set up the database on DB2
  • Installed Telecom Web Services Server base components on the database server
About this task

Complete the following steps on the database server. If you are using a distributed database configuration, complete the steps on each server that will host a database.

  1. Log in to the database server as root.
  2. Copy the contents of the following applicable directories from the server where you installed the TWSS base components to the corresponding location on the database server.
    • was_root/installableApps/TWSS-Base/database, where was_root represents the WebSphere® Application Server installation location (for a shared database)
    • esb_root/installableApps/TWSS-Base/database, where esb_root represents the installation location of the WebSphere ESB (for a distributed database, Access Gateway migration)
    • was_root/installableApps/TWSS-Services/database (for a distributed database, MMS/MM7, SMS/SMP and WAPPUSH/SMPP migration)
    Note: This step is not necessary if the database server is located on the same physical server as the TWSS base components.
  3. Run the following command to change the permissions on the database configuration script.
    chmod 755 crtsrvDb2.sh
  4. From the command line, switch to a user ID with database administrator authority, such as db2inst1. For example, type:
    su - db2inst1
  5. If you are not already in the directory to which you copied the database setup files, change to it. Example:
    cd was_root/installableApps/TWSS-Base/database
  6. Launch the crtsrvDb2 script using the following command:
    ./crtsrvDb2.sh options
    where: options corresponds to the following values.
    Table 1. crtsrvDb2 configuration values
    Parameter Description Recommended Value
    dbServer Fully qualified hostname for the database server. Example: myhost.example.com
    dbPort Database server connection port. 50000
    dbLocal TRUE if the database server is located on the same physical server as the TWSS base components.

    FALSE if the database server is on a different server. This is the typical configuration.

    TRUE
    dbNodeName Remote database server node name, when dbLocal is FALSE. This value is used for reference purposes and it is not the host name. RDBSRV
    dbName Name of the database. If you are using a consolidated or shared database configuration, the recommended name is TWSS71. If you are using a distributed database configuration, use a name that describes the function of this database–for example, AGDB for the Access Gateway. TWSS71
    dbAlias Database alias. If you are using a consolidated or shared database configuration, the recommended name is TWSS71A. If you are using a distributed database configuration, use a name that describes the function of this database–for example, AGDBA. TWSS71A
    dbLocale Database locale or territory code. US
    dbAdmin Administrator user ID for the database instance. Example: db2inst1
    dbAdminPW Password for the administrator user ID. not applicable
    dbUser User ID for accessing the database. twssuser
    dbUserPW Password for the database user ID. not applicable
    INITorDDLFile One of the following:
    • INIT to initialize the database instance
    • The path to the DDL file
    INIT
    infoflag TRUE to display informational messages while the database is being initialized.

    FALSE to suppress informational messages.

    TRUE
    Example (options are split across lines for ease in reading):
    ./crtsrvDb2.sh myhost.example.com 50000 TRUE RDBSRV TWSS71 TWSS71A 
    US db2inst1 password twssuser password INIT TRUE
Results
When the crtsrvDb2 command completes, the database server instance has been configured. The result of the command is that the TWSS 7.1 database is created. You can verify that it was created properly by running the db2 list database directory command, as the db2inst1 user.
What to do next
Next, you will run the First Steps script to complete the configuration for Telecom Web Services Server. The First Steps script will create the necessary database tables.



Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.