IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Install the DB2 Client Application Enabler with a remote Relational Database Management System - UNIX

Perform these steps only if the IBM DB2 Relational Database Management System (RDBMS) is installed on a separate computer from the client (the Managing Server).

Install the DB2 Client Application Enabler on the client computer and set up connectivity to IBM DB2. Follow these guidelines:

  1. Ensure there is no DB2 Client Application Enabler installation (either complete or partial) on the system. If an installation already exists, uninstall it.

  2. Customize the options to select Java database connectivity (JDBC). A JDBC driver is installed as part of the DB2 Client Application Enabler installation.

  3. Ensure that approximately 2 MB are available in the selected home directory to accommodate the DB2 Client Application Enabler.

    For IBM DB2 9, you need more than 2 MB of disk space. For IBM DB2 9, the disk space will be checked dynamically at client installation time. The disk space required for your product depends on the type of installation you choose and the type of file system you have. The DB2 Setup wizard provides dynamic size estimates based on the components selected during a typical, compact, or custom installation. Remember to include disk space for required software and communication products.

  4. Source the db2profile file (for the Korn or Bourne shell) or the db2cshrc file (for the C shell) to be able to run IBM DB2 commands and utilities such as catalog and connect.

    The db2profile and db2cshrc files are located in the home directory of the user, under the sqllib subdirectory. Source the appropriate file in the .profile or .cshrc file of each account that needs to use the IBM DB2 environment and tools.

  5. IBM AIX: To verify the setup of the RDBMS and of the DB2 client, ensure that the following environment variables are set correctly. (If you have sourced the db2profile or db2cshrc file, these variables are correct.)

    • DB2DIR must point to the directory where the DB2 Client Application Enabler is installed.

    • DB2INSTANCE must be set to the IBM DB2 instance name. This is set during installation of IBM DB2.

  6. You must set up connectivity both to the RDBMS server and to IBM DB2. IBM DB2 commands for setting up connectivity are issued from the client system. You must run these commands even when IBM DB2 is running on the same computer that hosts the Managing Server. Here are some examples:

    • The following example command connects the client with an RDBMS server named ghost, which has the node name or alias ims_db2 and uses port 50000: 
      db2 catalog tcpip node ims_db2 remote ghost server 50000

    • The following example command connects the client to a database named timsdev with the alias ims_dev, located on the server whose node name or alias is ims_db2: 
      db2 catalog database timsdev as ims_dev at node ims_db2

  7. Run the following command: 
    db2 terminate

  8. Provide extra shared memory segments for IBM DB2 connections on IBM AIX.

    By default, 32-bit applications cannot attach more than 11 shared memory segments per process, of which a maximum of 10 can be used for local IBM DB2 connections. Use the EXTSHM (extended shared memory) functionality to ensure that an adequate number of shared memory segments are available for IBM DB2 connections. The EXTSHM functionality is available for IBM DB2 7.2 (which is the result of installation of IBM DB2 7.1 Fix Pack 3) or for later versions of IBM DB2. If you do not provide an adequate number of shared memory segments, you might see the following error message: 

    SQL1224N  A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force
command. SQLSTATE=55032

    Enable EXTSHM as follows:


    How to enable EXTSHM

    In IBM DB2 client sessions export EXTSHM=ON
    When starting the IBM DB2 Server 
    export EXTSHM=ON 
db2set DB2ENVLIST=EXTSHM 
db2start
    On IBM DB2 EE 
    EXTSHM=ON 
export EXTSHM
    You also add these lines to the sqllib/userprofile file.


Parent topic:

Prepare an existing IBM DB2 environment

+

Search Tips   |   Advanced Search