InfoScale™ 9.0 Cluster Server Agent for DB2 Installation and Configuration Guide - Solaris

Last Published:
Product(s): InfoScale & Storage Foundation (9.0)
Platform: Solaris
  1. Introducing the Cluster Server Agent for DB2
    1.  
      About the Cluster Server Agent for DB2
    2.  
      How Cluster Server Agent for DB2 makes DB2 highly available
    3.  
      How the DB2 agent supports intelligent resource monitoring
    4.  
      Supported software for VCS agent for DB2
    5. About agent functions for VCS agent for DB2
      1.  
        About the online agent function for VCS agent for DB2
      2.  
        About the offline agent function for VCS agent for DB2
      3.  
        About the monitor agent function for VCS agent for DB2
      4.  
        About the clean agent function for VCS agent for DB2
      5.  
        About the info agent function for VCS agent for DB2
      6.  
        About the action agent function for VCS agent for DB2
      7. About IMF Integration functions for VCS Agent for DB2
        1.  
          About the imf_init function for VCS agent for DB2
        2.  
          About the imf_register function for VCS agent for DB2
        3.  
          About the imf_getnotification function for VCS agent for DB2
      8.  
        About running the info agent function to get database information for VCS agent for DB2
    6.  
      Typical DB2 configuration in a Cluster Server
    7.  
      Road map for setting up DB2 UDB in a VCS environment
  2. Installing and configuring DB2
    1. VCS requirements for installing DB2
      1.  
        Preparing to install DB2 UDB non-MPP versions
      2.  
        Preparing to install DB2 UDB MPP versions
      3.  
        Creating the file systems for non-MPP instances for DB2
      4.  
        Creating the shared file systems for MPP instances for DB2
      5. Defining user and group accounts for DB2
        1.  
          Creating user group accounts for DB2
        2.  
          Adding user accounts for DB2 on Solaris
    2.  
      Installing DB2 in a VCS environment
    3. Setting up the DB2 configuration
      1.  
        Checking /etc/services for DB2
      2.  
        Enabling password less communication for DB2 users among all cluster nodes
      3.  
        Modifying the $DB2InstHome/sqllib/db2nodes.cfg file for DB2
      4.  
        Confirming the DB2 installation
  3. Installing and removing the Cluster Server Agent for DB2
    1.  
      Before you install or upgrade the VCS agent for DB2
    2.  
      Installing the VCS agent for DB2 software
    3.  
      Upgrading the VCS agent for DB2
    4.  
      Disabling the VCS agent for DB2
    5.  
      Removing the VCS agent for DB2
  4. Configuring VCS service groups for DB2
    1.  
      About configuring service groups for DB2
    2. About DB2 configurations in VCS
      1.  
        Non-MPP configuration service groups for DB2
      2. MPP configuration service groups for DB2
        1.  
          Parallel CVM service group for MPP configuration for DB2
        2.  
          Failover service group for MPP configuration for DB2
      3.  
        DB2 instances that are configured in Solaris zones
    3. Before configuring the service group for DB2
      1.  
        Importing the Db2udbTypes.cf file
    4. Configuring the VCS Agent for DB2 from Cluster Manager (Java Console)
      1.  
        Adding service group for DB2 MPP using the Cluster Manager (Java Console)
      2.  
        Adding a service group for DB2 non-MPP with the Cluster Manager (Java Console)
    5. Configuring the VCS agent for DB2 by editing the main.cf file
      1.  
        Configuring the agent to use the DB2 MPP configuration
      2.  
        Configuring the agent to use the DB2 non-MPP configurations
      3.  
        Verifying the configuration for VCS agent for DB2
    6. Setting up in-depth monitoring of a DB2 instance
      1.  
        Enabling in-depth monitoring of a DB2 instance
      2.  
        Enabling in-depth monitoring from the command line for DB2
      3. Enabling and disabling intelligent resource monitoring for Db2udb resource
        1.  
          Administering the AMF kernel driver
      4.  
        Handling DB2 error codes during in-depth monitoring
      5.  
        Disabling in-depth monitoring for DB2
  5. Administering VCS service groups for DB2
    1.  
      About administering service groups for DB2
    2.  
      Bringing the DB2 service group online
    3.  
      Taking the DB2 service group offline
    4.  
      Switching the DB2 service group
    5.  
      Disabling the agent for DB2
  6. Appendix A. Troubleshooting Cluster Server Agent for DB2
    1.  
      Creating a db2profile for environment variables for DB2
    2.  
      Setting the RestartLimit attribute for VCS agent for DB2
    3.  
      Partition/Node switch-over scenarios for DB2 in MPP mode
  7. Appendix B. Resource type information for Cluster Server Agent for DB2
    1. About the resource type definitions for DB2
      1.  
        DB2 UDB type definition file: Db2udbTypes.cf on Solaris
  8. Appendix C. Resource type attributes for DB2
    1.  
      About the Db2udb resource types and attribute definitions
  9. Appendix D. Sample configurations
    1. Sample configuration files for VCS agent for DB2 on Solaris
      1.  
        Non-MPP main.cf configuration for VCS agent for DB2 on Solaris
      2.  
        MPP main.cf configuration for VCS agent for DB2 on Solaris

Installing the VCS agent for DB2 software

The agent binaries for Cluster Server Agent for DB2 is part of VRTSvcsea package. The VRTSvcsea package is already installed if you chose to install all packages or recommended packages during VCS installation. You must manually install the VRTSvcsea package if you installed minimal packages during VCS installation.

You can install the Cluster Server Agent for DB2 from the product disc. You must install the VCS agent for DB2 enterprise agent on all nodes that will host the DB2 service group.

To install the agent on a Solaris SPARC node

  1. Log in as superuser.
  2. Make sure that the agent is not already installed. Navigate to /opt/VRTSagents/ha/bin and list the contents of the directory.

    If the command returns the VCS agents for DB2, you can skip this procedure.

  3. Create a temporary directory for installation:
    # mkdir /tmp/install

  4. Insert the disc into a drive connected to your node:

    • If you are running Solaris volume-management software, the software automatically mounts the disc as/cdrom/sxrt-6.0-dvd1-sol_sparc. Type the following command to go to the location:

      # /cdrom/sxrt-6.1.0-dvd1-sol_sparc

    • If you are not running Solaris volume-management software, you must mount the disc manually. For example:

      # mount -F hsfs -o ro /dev/dsk/c0t6d0s2 /cdrom

      Where, in this example, /dev/dsk/c0t6d0s2 is the default for the CD drive. After the disc is mounted, go to the location where the package files are present:

      # cd /cdrom
  5. Copy the package files from the software disc to the temporary directory:
    # cp -r pkgs/* /tmp/install
  6. Navigate to the temporary directory and install the package:
    # cd /tmp/install
# pkgadd -d VRTSvcsea.pkg

    The VRTSvcsea package includes the agent binaries for the DB2 agent. The package also installs the VCS agents for Oracle and Sybase.

To install the language pack

  1. Log in as superuser.

  2. After installing the agent, insert the language disc into a drive connected to the system.

    • If you are running Solaris volume-management software, the software automatically mounts the disc as /cdrom. Type the following command to go to the location:

      # cd /cdrom

    • If you are not running Solaris volume-management software, you must mount the disc manually. For example:

      # mount -F hsfs -o ro /dev/dsk/c0t6d0s2 /cdrom

      Where, in this example, /dev/dsk/c0t6d0s2 is the default for the CD drive.

      After the disc is mounted, go to the location where the package files are present:

      # cd /cdrom
  3. Copy the package files from the language disc to a temporary directory:
    # cp -r pkgs/* /tmp
  4. Navigate to the temporary directory and install the VRTSjacse.pkg file.
    # cd /tmp
# pkgadd -d VRTSjacse.pkg