The following main.cf configuration file reflects DB2 UDB in an 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 = bge0 Address = "192.2.40.21" ) Mount db2mnt1 ( MountPoint = "/db2_mnt/db2inst1" BlockDevice = "/dev/vx/dsk/db2dg1/db2dg1home" FSType = vxfs MountOpt = rw FsckOpt = "-y" ) NIC db2nic1 ( Device = bge0 NetworkType = ether ) 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