Symantec logo

MPP main.cf configuration: DB2 UDB ESE
multi-partition instance

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 CVM service group, which manages the shared storage in the cluster.

include "types.cf"

include "CFSTypes.cf"

include "CVMTypes.cf"

include "/etc/VRTSagents/ha/conf/Db2udb/Db2udbTypes.cf"

cluster db2_aix_mpp (

UserNames = { admin = gpqIpkPmqLqqOyqKpn }

Administrators = { admin }

HacliUserLevel = COMMANDROOT

CounterInterval = 5

)

system sysA (

)

system sysB (

)

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"

MountOpt = "cluster"

NodeList = { sysA, sysB, sysC, sysD }

)

CFSfsckd vxfsckd (

)

CVMCluster cvm_clus (

CVMClustName = db2_aix_mpp

CVMNodeId = { sysA = 0, sysB = 1, sysC = 2, sysD = 3 }

CVMTransport = gab

CVMTimeout = 200

)

CVMVolDg db2dg (

CVMDiskGroup = cdb2dg1

CVMActivation = sw

)

CVMVxconfigd cvm_vxconfigd (

Critical = 0

CVMVxconfigdArgs = { syslog }

)

cvm_clus requires cvm_vxconfigd

db2cfsmnt requires db2dg

db2cfsmnt requires vxfsckd

db2dg requires cvm_clus

vxfsckd requires cvm_clus

// resource dependency tree

//

//          group cvm

//          {

//          CFSMount db2cfsmnt

//              {

//              CVMVolDg db2dg

//               {

//               CVMCluster cvm_clus

//                  {

//                   CVMVxconfigd cvm_vxconfigd

//                   }

//              }

//               CFSfsckd vxfsckd

//                   {

//                   CVMCluster cvm_clus

//                       {

//                       CVMVxconfigd cvm_vxconfigd

//                       }

//                   }

//               }

//          }

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

)

IP Db2_IP0 (

Device = en0

Address = "11.192.10.32"

NetMask = "255.255.244.0"

)

NIC mynic0 (

Device = en0

NetworkHosts = { "11.192.11.90" }

)

requires group cvm online local firm

Db2_IP0 requires mynic0

db2udb0 requires Db2_IP0

// resource dependency tree

//

//          group db2mpp_grp0

//          {

//          Db2udb db2udb0

//               {

//               IP Db2_IP0

//                   {

//                   NIC mynic0

//                   }

//               }

//          }

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

)

IP Db2_IP1 (

Device = en0

Address = "11.192.10.33"

NetMask = "255.255.244.0"

)

NIC mynic1 (

Device = en0

NetworkHosts = { "11.192.11.90" }

)

requires group cvm online local firm

Db2_IP1 requires mynic1

db2udb1 requires Db2_IP1

// resource dependency tree

//

//          group db2mpp_grp1

//          {

//          Db2udb db2udb1

//               {

//               IP Db2_IP1

//                   {

//                   NIC mynic1

//                   }

//               }

//          }

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

)

IP Db2_IP2 (

Device = en0

Address = "11.192.10.33"

NetMask = "255.255.244.0"

)

NIC mynic2 (

Device = en0

NetworkHosts = { "11.192.11.90" }

)

requires group cvm online local firm

Db2_IP2 requires mynic2

db2udb2 requires Db2_IP2

// resource dependency tree

//

//          group db2mpp_grp2

//          {

//          Db2udb db2udb2

//               {

//               IP Db2_IP2

//                   {

//                   NIC mynic2

//                   }

//               }

//          }

group db2mpp_grp3 (

SystemList = { sysA = 0, sysB = 1, sysC = 2, sysD = 3 }

AutoStartList = { sysD }

)

Db2udb db2udb3 (

DB2InstOwner = db2inst1

DB2InstHome = "/db2_mnt/db2inst1"

NodeNumber = 3

)

IP Db2_IP3 (

Device = en0

Address = "11.192.10.33"

NetMask = "255.255.244.0"

)

NIC mynic3 (

Device = en0

NetworkHosts = { "11.192.11.90" }

)

requires group cvm online local firm

Db2_IP3 requires mynic3

db2udb3 requires Db2_IP3

// resource dependency tree

//

//          group db2mpp_grp3

//          {

//          Db2udb db2udb3

//               {

//               IP Db2_IP3

//                   {

//                   NIC mynic3

//                   }

//               }

//          }