Non-MPP main.cf configuration for Solaris

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