InfoScale™ 9.0 Cluster Server Agent for DB2 Installation and Configuration Guide - AIX

To start adding the service group for the DB2 MPP database

1. In the Cluster Explorer window, click the Add Service Group icon on the toolbar.
2. In the Add Service Group window, enter the name of the service group you want to create for the service group. For example, enter db2mpp_grp1. Do not press Return or Enter.
3. In the Available Systems box, double-click the systems that you want in your configuration.
4. Select the system where you want to automatically start the service group. In the window that shows the systems in the configuration, select the check box next to the system.
5. Click the Failover radio button to specify the Service Group Type.

To select the template for the DB2 MPP database

1. Click the Templates button.
2. In the Select Templates window, select db2udb_mpp_grp from the list in the Templates box. The Dependency graph information and the Types information should change to reflect the template choice. Click OK. In the Add Service Group window, the name of the template is now shown as selected.
3. Click OK on at the bottom of the Add Service Group window. The group is added. On the left pane of the Cluster Manager (Java Console) window, the service group is under the CVM service group. On the Status tab, the group is shown Offline on each system.

To configure the resources for the DB2 MPP database

1. In the left pane, double-click the db2mpp_grp1 service group. The types of resources that you can configure for the group appear: Db2udb, IP, and NIC.
2. Double-click the Db2udb resource type. Select the resource, db2udb, which is under the Db2udb type. Click the Properties tab.
3. On the Properties tab for the db2udb resource, a list of Type Specific Attributes is shown. click the Edit icon for each attribute you want to configure. In the Edit Attribute window, enter the necessary attribute value information. For example, enter the db2inst1 as the value for DB2InstOwner.
4. Assign values for the IP and the NIC resources in the same manner as you assigned values to the db2udb resource: double-click the type to display the resource and select the resource. With the Properties tab visible, you can edit the Type Specific Attributes for each resource.
5. Right-click the db2mpp_grp1 service group in the left pane. Click Link in the drop-down menu.

   The Link Service Groups window shows the following:

   • The Parent Group as db2mpp_grp1

   • The Child group as CVM

   • The Relationship as "online local"

   • The Dependency Type as "firm"

6. Click OK to create the dependency link.

To finalize the service group for the DB2 MPP database

1. Click the Save Configuration icon.
2. Enable the db2udb and IP resources. Right-click a resource and select Enabled in the drop-down menu. If necessary, make the configuration read and write.
3. Click the Online Service Group icon.
4. In the window, select the service group and the system that you want to bring online. Click OK.