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 db2_clus (
UserNames = { admin = "cDRpdxPmHpzS." }
Administrators = { admin }
CounterInterval = 5
)
system sysA (
CPUUsageMonitoring = { Enabled = 0, ActionThreshold = 0,
ActionTimeLimit = 0, Action = NONE,
NotifyThreshold = 0, NotifyTimeLimit = 0 }
)
system sysB (
CPUUsageMonitoring = { Enabled = 0, ActionThreshold = 0,
ActionTimeLimit = 0, Action = NONE,
NotifyThreshold = 0, NotifyTimeLimit = 0 }
)
group db2udb_grp1 (
SystemList = { sysA= 0, sysB = 1 }
AutoStartList = { sysA }
)
Db2udb db2udb1 (
DB2InstOwner = db2inst1
DB2InstHome = "/db2inst1"
IndepthMonitor = 1
DatabaseName = SAMPLE
)
DiskGroup db2udb_dg1 (
DiskGroup = db2_dg1
)
IP db2udb_ip1 (
Device = en0
Address = "166.98.9.163"
NetMask = "255.255.220.0"
)
Mount db2udb_mnt1 (
MountPoint = "/db2inst1"
BlockDevice = "/dev/vx/dsk/db2_dg1/inst1_vol"
FSType = vxfs
MountOpt = rw
)
NIC db2udb_nic1 (
Device = en0
NetworkHosts = { "166.98.128.180" }
)
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_grp2 (
SystemList = { sysA = 0, sysB = 1 }
AutoStartList = { sysA }
)
Db2udb db2udb2 (
DB2InstOwner = db2inst2
DB2InstHome = "/db2inst2"
IndepthMonitor = 1
DatabaseName = MYDB
)
IP db2udb_ip2 (
Device = en0
Address = "166.98.9.168"
NetMask = "255.255.220.0"
)
LVMVG db2udb_vg00 (
VolumeGroup = vg00
MajorNumber = 50
Disks = { hdisk2, hdisk3 }
VaryonvgOpt = p
)
Mount db2udb_mnt2 (
MountPoint = "/db2inst2"
BlockDevice = "/dev/vg00"
FSType = jfs
MountOpt = rw
)
NIC db2udb_nic2 (
Device = en0
NetworkHosts = { "166.98.128.181" }
)
db2udb2 requires db2udb_ip2
db2udb2 requires db2udb_mnt2
db2udb_ip2 requires db2udb_nic2
db2udb_mnt2 requires db2udb_vg00
// resource dependency tree
//
// group db2udb_grp2
// {
// Db2udb db2udb2
// {
// IP db2udb_ip2
// {
// NIC db2udb_nic2
// }
// Mount db2udb_mnt2
// {
// LVMVG db2udb_vg00
// }
// }
// }