IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Prepare the remote IBM DB2 for use with the Managing Server

The following instructions describe how to prepare the DB2 environment used by the Managing Server when DB2 is installed on a different computer to the Archive Agent (a component of the Managing Server).

  1. Install IBM DB2 on the remote server.

    On the remote server, a user account, for example, amuser must be created. This user must also be created on the server where the Managing Server is being installed.

  2. Login as the DB2 Instance user on the remote server.

  3. Create a temporary directory on the remote server in which to place the database installation scripts. Example: /tmp.

  4. FTP the file db2-remote-scripts.tar to the temporary directory you just created.

    The db2-remote-scripts.tar file is provided with the Managing Server distribution in MS_/path/to/install/base/scripts/.

  5. Untar the db2-remote-scripts.tar file.

  6. Run the db2install.sh file as the DB2 Instance user. You will also need the password for the Schema user. 
    cd /tmp/db2/bin
    sh db2install.sh db_username schema_user absolute path installation dir 
        user_interface_user DB2version databaseName

    Notes:

    1. db_username must have dba privileges, for example, db2inst.

    2. schema_user owns and can create the database tables for ITCAM for Application Diagnostics. This is the user you created in Existing database environment: creating the Schema user. When you run the script you will get prompted for a password.

    3. The absolute path installation directory is a db2 subdirectory in the temporary directory containing the installation scripts, for example, /tmp/db2.

    4. user_interface_user is the user to be used when logging in and operating the Managing Server's Application Monitor after installation and configuration. This will also be specified during the Managing Server installation. This is the user you created in Custom installation and upgrade: creating the user interface user.

    5. The db2install.sh script invokes the scripts db2configuration.sh and db2createschema.sh. The db2configuration.sh script invokes the script dbsettings.sql, and the db2createschema.sh script invokes the am-db2.sql script.


Parent topic:

Prepare an existing IBM DB2 environment

+

Search Tips   |   Advanced Search