Symantec logo

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

The following configuration reflects DB2 UDB with two instances configured in a ESE single-partition instance environment.

include "types.cf"

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

cluster vcs (

CounterInterval = 5

)

system vcstc1 (

CPUUsageMonitoring = { Enabled = 0, ActionThreshold = 0,

ActionTimeLimit = 0, Action = NONE, NotifyThreshold = 0,

NotifyTimeLimit = 0 }

)

system vcstc2 (

CPUUsageMonitoring = { Enabled = 0, ActionThreshold = 0,

ActionTimeLimit = 0, Action = NONE, NotifyThreshold = 0,

NotifyTimeLimit = 0 }

)

group db2udb_grp1 (

SystemList = { vcstc1= 0, vcstc2 = 1 }

AutoStartList = { vcstc1 }

)

Db2udb db2udb1 (

DB2InstOwner = db2inst1

DB2InstHome = "/db2inst1"

IndepthMonitor = 1

DatabaseName = SAMPLE

)

DiskGroup db2udb_dg1 (

DiskGroup = db2_dg1

)

IP db2udb_ip1 (

Device = eth0

Address = "166.98.9.163"

NetMask = "255.255.252.0"

)

Mount db2udb_mnt1 (

MountPoint = "/db2inst1"

BlockDevice = "/dev/vx/dsk/db2_dg1/inst1_vol"

FSType = vxfs

MountOpt = rw

FsckOpt = "-n"

)

NIC db2udb_nic1 (

Device = eth0

)

Volume db2udb_vol1 (

Volume = inst1_vol

DiskGroup = db2_dg1

)

db2udb1 requires db2udb_ip1

db2udb1 requires db2udb_mnt1

db2udb_ip1 requires db2udb_nic1

db2udb_mnt1 requires db2udb_vol1

db2udb_vol1 requires db2udb_dg1

// resource dependency tree

//

//          group db2udb_grp1

//          {

//          Db2udb db2udb1

//                {

//                IP db2udb_ip1

//                      {

//                      NIC db2udb_nic1

//                      }

//                Mount db2udb_mnt1

//                      {

//                      Volume db2udb_vol1

//                            {

//                            DiskGroup db2udb_dg1

//                            }

//                      }

//                }

//          }

group db2udb_grp3 (

SystemList = { vcstc1 = 0, vcstc2 = 1 }

AutoStartList = { vcstc1 }

)

Db2udb db2udb3 (

DB2InstOwner = db2inst3

DB2InstHome = "/db2inst3"

IndepthMonitor = 1

DatabaseName = MYDB

)

DiskGroup db2udb_dg3 (

DiskGroup = db2_dg3

)

IP db2udb_ip3 (

Device = eth0

Address = "192.2.40.21"

NetMask = "255.255.252.0"

)

Mount db2udb_mnt3 (

MountPoint = "/db2inst3"

BlockDevice = "/dev/vx/dsk/db2_dg3/inst3_vol"

FSType = vxfs

MountOpt = rw

FsckOpt = "-n"

)

NIC db2udb_nic3 (

Device = eth0

)

Volume db2udb_vol3 (

Volume = inst3_vol

DiskGroup = db2_dg3

)

db2udb3 requires db2udb_ip3

db2udb3 requires db2udb_mnt3

db2udb_ip3 requires db2udb_nic3

db2udb_mnt3 requires db2udb_vol3

db2udb_vol3 requires db2udb_dg3

// resource dependency tree

//

//          group db2udb_grp3

//          {

//          Db2udb db2udb3

//                {

//                IP db2udb_ip3

//                      {

//                      NIC db2udb_nic3

//                      }

//                Mount db2udb_mnt3

//                      {

//                      Volume db2udb_vol3

//                            {

//                            DiskGroup db2udb_dg3

//                            }

//                      }

//                }

//          }