Cluster Server 7.3.1 Agent for DB2 インストール/設定ガイド - Solaris

Solaris での VCS agent for DB2 の場合 MPP main.cf の設定

次の設定ファイルは、ESE マルチパーティションインスタンス MPP 環境での DB2 UDB を示します。4 つのデータベースパーティションが設定されています。各クラスタノードで 1 つのパーティションが設定されています。各データベースサービスグループは、クラスタの共有ストレージを管理する同じ CVM サービスグループに依存しています。

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
         )