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 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 db2_grp1 (
SystemList = { sysA = 0, sysB = 1 }
AutoStartList = { sysA }
)
Db2udb db2udb1 (
DB2InstOwner = db2inst1
DB2InstHome = "/db2_mnt/db2inst1"
IndepthMonitor = 1
DatabaseName = DWCNTRL
NodeNumber = 0
)
Db2udb db2udb2 (
DB2InstOwner = db2inst1
DB2InstHome = "/db2_mnt/db2inst1"
IndepthMonitor = 0
NodeNumber = 1
)
DiskGroup db2dg1 (
DiskGroup = db2dg1
)
IP db2ip1 (
Device = en0
Address = "166.98.9.188"
NetMask = "255.255.220.0"
)
Mount db2mnt1 (
MountPoint = "/db2_mnt/db2inst1"
BlockDevice = "/dev/vx/dsk/db2dg1/db2dg1home"
FSType = vxfs
MountOpt = rw
)
NIC db2nic1 (
Device = en0
NetworkHosts = { "166.98.128.180" }
)
Volume db2vol1 (
Volume = db2dg1home
DiskGroup = db2dg1
)
db2ip1 requires db2nic1
db2mnt1 requires db2vol1
db2udb1 requires db2ip1
db2udb1 requires db2mnt1
db2vol1 requires db2dg1
db2udb2 requires db2ip1
db2udb2 requires db2mnt1