Configuring database groups for use with InfoSphere® Optim™ Query Workload Tuner

To be able to capture a workload from the statement cache on all subsystems of a data sharing group, you must configure a database group in the client. This database group must contain the same members of the data sharing group in a Parallel Sysplex® in your DB2® for z/OS® environment.

Before you begin

About this task

A data sharing group is a collection of one or more DB2 for z/OS subsystems that share DB2 data. A DB2 subsystem that belongs to a data sharing group is a member of that group. Each member can belong to one, and only one, data sharing group. All members of a data sharing group share the same DB2 catalog and directory, and all members must be in the same Parallel Sysplex. Data sharing improves the availability of DB2 data, extends the processing capacity of the system, provides more flexible ways to configure your environment, and increases transaction rates.

The SQL statements that are used by an application can run on multiple subsystems. If these subsystems are members of a data sharing group, you can configure a database group in the client to contain the same members. You can then define a workload to contain all SQL statements of the application from the statement cache, and capture the workload from the data sharing group.

For information about how data sharing work, see these references:

Procedure

To configure a database group in the client:

  1. To open the Database Groups view, click the Database Groups tab. If the tab is not visible, click Window > Show View > Database Groups.
  2. Configure a database group by creating a group and adding the same members of the data sharing group. Ensure that the connection profiles of a subsystem are correct when you add the subsystem to a group.