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
// }
// }
// }
// }