How to implement support for Db2 subsystems that are members of a Db2 Data Sharing Group within Sysview for Db2

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Requirement to see all threads that are active in all members of a Db2 Data Sharing group on a single Active Threads list.
What is the correct procedure for implementing support for Db2 Data Sharing in Sysview for Db2 for z/OS (IDB2)?

The process involves updating the IDB2 Data Collector (DC) system parameters: DBSUB, DB2-LOCATION, DATASHARING and DC-GROUP; coding the correct location name in the APPLS parameter; code correct DBSUB, DB2LOC parameters in the EXEC PARM statement in the IDB2 DC started task JCL.

If members of the DS group are on different, i.e., remote Lpars, then one must also implement the RAF facility
This will allow IDB2 to connect to the remote IDB2 DC.

Resolution

To implement support for a Db2 Datasharing Group in IDB2, the following must be done.

Assume one has two DB2 members in a DS group.
Group name is DSN0.
First member is DSN1; second member is DSN2.

Typical naming conventions would have three IDB2 parameter members in the SOURCE product library.
IDDCPRMS would be parameters applicable to all DCs.
APPLS would be the list of DB2 ssids being monitored.
DSN1SYSP would be parameters specific to DSN1 ssid.
DSN2SYSP would be parameter specific to DSN2 ssid.

1. Implement the following IDB2 parameters in DSN1SYSP and DSN2SYSP:
   DSN1SYSP:
   ...
   DBSUB=DSN1 /* Identify DB2 DS member/ssid */
   DATASHARING=YES /* This turns on Insight's support for DS */
   DC-GROUP=DCGDSN0 /* Implements an Insight Data Collector Group in the SYSPLEX */
   DB2-LOCATION=IDB2LOCDSN0 /* 16 characters used to further identify DB2 ssid */
   ...
   DSN2SYSP:
   ...
   DBSUB=DSN2
   DATASHARING=YES
   DC-GROUP=DCGDSN0
   DB2-LOCATION=IDB2LOCDSN0
   ...
   
   
2. Implement the following in the APPLS member:
   
   APPLS= (
   IDB2LOCDSN0,DSN1,NOTRAF /* DB2-LOCATION,DBSUB,RAF Vtam Applid */
   IDB2LOCDSN0,DSN2,NOTRAF
   )
   
   
3. The IDB2 DC started task JCL proc would code:
   ...
   //IDB2DC EXEC PGM ....
   // PARM=('/DBSUB=DSN1,DBLOC=IDB2LOCDSN0,...')
   
   The IDB2 Data Collector Group (DC-GROUP) is similar to Db2's Data Sharing Group. The IDB2 DC Group name must be unique within the sysplex, so do NOT use the DB2 DS group name.
   And a unique DC-GROUP must be coded for each DS group within the Sysplex that is being monitored by IDB2. Can be maximum of any 8 characters in length.
   If DATASHARING=YES, and no DC-GROUP name is coded, then the default used is XDBGDCxx, where xx is the release. For r12 it would be XDBGDC12.

Note that DB2-LOCATION is the same for both DB2 ssids being monitored. This is required to implement support for DS in IDB2. All members being monitored by IDB2 must use the same location name. Can be a maximum of any 16 characters in length.

The same location string must be used for DB2-LOCATION, the DB2-LOCATION parameter in the APPLS member, and the DB2LOC parameter on the EXEC PARM of the Insight DC JCL.

If one or more members of the DS group are on remote Lpars, then you must implement the Remote Access Facility.