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.
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.
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.