Symantec logo

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