I want to be able to see all threads that are active in all members of a DB2 Data Sharing group on a single Active Threads list. What's the correct procedure for implementing support for DB2 Data Sharing in Insight?
The process involves updating the Insight 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 Insight 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 as documented in the Insight System Guide in Chapter 4.
This will allow Insight to connect to the remote Insight DC.
To implement support for a DB2 Datasharing Group in Insight, 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 Insight 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 Insight. All members being monitored by Insight 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.
This is documented in the Insight System Guide, Chapter 3.
If one or more members of the DS group are on remote Lpars, then you must implement the Remote Access Facility. Full details are in the Insight System Guide, Chapter 4. It is not covered here.