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
StartUpOpt = ACTIVATEDB
)
DiskGroup db2udb_dg1 (
DiskGroup = db2_dg1
)
IP db2udb_ip1 (
Device = hme0
Address = "166.98.9.163"
)
Mount db2udb_mnt1 (
MountPoint = "/db2inst1"
BlockDevice = "/dev/vx/dsk/db2_dg1/inst1_vol"
FSType = vxfs
MountOpt = rw
FsckOpt = "-y"
)
NIC db2udb_nic1 (
Device = hme0
NetworkType = ether
)
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
)
DiskGroup db2udb_dg2 (
DiskGroup = db2_dg2
)
IP db2udb_ip2 (
Device = hme0
Address = "192.2.40.21"
)
Mount db2udb_mnt2 (
MountPoint = "/db2inst2"
BlockDevice = "/dev/vx/dsk/db2_dg2/inst2_vol"
FSType = vxfs
MountOpt = rw
FsckOpt = "-y"
)
NIC db2udb_nic2 (
Device = hme0
NetworkType = ether
)
Volume db2udb_vol2 (
Volume = inst2_vol
DiskGroup = db2_dg2
)
db2udb2 requires db2udb_ip2
db2udb2 requires db2udb_mnt2
db2udb_ip2 requires db2udb_nic2
db2udb_mnt2 requires db2udb_vol2
db2udb_vol2 requires db2udb_dg2
// resource dependency tree
//
// group db2udb_grp2
// {
// Db2udb db2udb2
// {
// IP db2udb_ip2
// {
// NIC db2udb_nic2
// }
// Mount db2udb_mnt2
// {
// Volume db2udb_vol2
// {
// DiskGroup db2udb_dg2
// }
// }
// }
// }
