Cluster Server 8.0.2 Agent for DB2 Installation and Configuration Guide - Solaris

MPP main.cf configuration for VCS agent for DB2 on Solaris

The following configuration file reflects DB2 UDB in an ESE multi-partition instance MPP environment. Four database partitions are shown. One partition is configured on each cluster node. Each database service group depends on the same CVM service group, which manages the shared storage in the cluster.

include "types.cf"
include "CFSTypes.cf"
include "CVMTypes.cf"
include "Db2udbTypes.cf"

cluster db2_mpp (
     CounterInterval = 5
     )

system sysA (
     )

system sysB (
     )

system sysC (
     )

system sysD (
     )

group cvm (
     SystemList = { sysA = 0, sysB = 1, sysC = 2, sysD = 3 }
     AutoFailOver = 0
     Parallel = 1
     AutoStartList = { sysA, sysB, sysC, sysD }
     )

    CFSMount db2cfsmnt (
        MountPoint = "/db2_mnt/db2inst1"
        BlockDevice = "/dev/vx/dsk/cdb2dg1/cdb2dg1home"
        Primary = sysD
        )

        CFSfsckd vxfsckd (
        )

    CVMCluster cvm_clus (
        Critical = 0
        CVMClustName = db2_mpp
        CVMNodeId = { sysA = 0, sysB = 1, sysC = 2, 
            sysD = 3 }
        CVMTransport = gab
        CVMTimeout = 200
        )

    CVMVolDg db2dg (
        CVMDiskGroup = cdb2dg1
        CVMVolume = { cdb2dg1home }
        CVMActivation = sw
        )

    db2cfsmnt requires db2dg
    db2cfsmnt requires vxfsckd
    db2dg requires cvm_clus
    vxfsckd requires qlogckd

    // resource dependency tree
    //
    //          group cvm
    //          {
    //          CFSMount db2cfsmnt
    //              {
    //              CVMVolDg db2dg
    //                  {
    //                  CVMCluster cvm_clus
    //                  }
    //              CFSfsckd vxfsckd
    //                  {
    //                  CFSQlogckd qlogckd
    //                  }
    //              }
    //          }

group db2mpp_grp0 (
     SystemList = { sysA = 0, sysB = 1, sysC = 2, sysD = 3 }
     AutoStartList = { sysA }
     )
  
     Db2udb db2udb0 (
          DB2InstOwner = db2inst1
          DB2InstHome = "/db2_mnt/db2inst1"
          IndepthMonitor = 1
          DatabaseName = SAMPLE
          )

   

group db2mpp_grp1 (
     SystemList = { sysA = 0, sysB = 1, sysC = 2, sysD = 3 }
     AutoStartList = { sysB }
     )

     Db2udb db2udb1 (
         DB2InstOwner = db2inst1
         DB2InstHome = "/db2_mnt/db2inst1"
         IndepthMonitor = 1
         DatabaseName = TEST1
         NodeNumber = 1
         )

    

group db2mpp_grp2 (
    SystemList = { sysA = 0, sysB = 1, sysC = 2, sysD = 3 }
    AutoStartList = { sysC }
    )

    Db2udb db2udb2 (
        DB2InstOwner = db2inst1
        DB2InstHome = "/db2_mnt/db2inst1"
        IndepthMonitor = 1
        DatabaseName = TEST2
        NodeNumber = 2
        )


group db2mpp_grp3 (
    SystemList = { sysA = 0, sysB = 1, sysC = 2, sysD = 3 }
    AutoStartList = { sysD }
    )

    Db2udb db2udb3 (
         DB2InstOwner = db2inst1
         DB2InstHome = "/db2_mnt/db2inst1"
         NodeNumber = 3
         )