Symantec logo

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

The following main.cf configuration file reflects DB2 UDB in a ESE multi-partition instance SMP environment. Two database partitions are shown.

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

NodeNumber = 0

)

Db2udb db2udb2 (

DB2InstOwner = db2inst1

DB2InstHome = "/db2inst1"

IndepthMonitor = 0

NodeNumber = 1

)

DiskGroup db2udb_dg1 (

DiskGroup = db2_dg1

)

IP db2udb_ip1 (

Device = eth0

Address = "166.98.9.163"

NetMask = "255.255.252.0"

)

IP db2udb_ip2 (

Device = eth0

Address = "166.98.9.165"

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

db2udb2 requires db2udb_ip2

db2udb2 requires db2udb_mnt1

db2udb_ip1 requires db2udb_nic1

db2udb_ip2 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

//                            }

//                      }

//                }

//          Db2udb db2udb2

//                {

//                IP db2udb_ip2

//                      {

//                      NIC db2udb_nic1

//                      }

//                Mount db2udb_mnt1

//                      {

//                      Volume db2udb_vol1

//                            {

//                            DiskGroup db2udb_dg1

//                            }

//                      }

//                }

//          }