Have all of the necessary setup procedures in place with the correct information in the CE-APM properties file along with the correct setup
in the Xnet STC and Sysview Performance Management Option for Db2 for z/OS (IDB2) data collector STC to facilitate successful communication
between all of the necessary components, but not getting Db2 metrics passed back to the CE-APM agent via IDB2.
Review of the IDB2 data collector job output reveals the following messages that are reiterated over and over again in the log:
DBG44032I USER SESSION CONNECTED: CEAPM-SYSVDB2
DBG44033I USER xxxxxx -GUSERS SECURITY BLOCK COMMAND CONNECT
DBG82001I NUAGTDSP - RETURN CODE FROM NUINSUB = 36 FOR REQUEST DSQPARMS ELAPSED
DBG44031I USER SESSION DISCONNECTED: CEAPM-SYSVDB2
These messages are occurring because the ID associated with the CE-APM connection to Xnet and IDB2
is not passing the IDB2 Security file check, thus preventing the ID from obtaining data.
The ID in question, xxxxxx, is failing the IDB2 security check. The addition of the following line in the Security file resolves this.
Under the line: (TYPE=USER,$-Z9999999,*,SYSADM), /*EVERYONE IS SYSADM
add: (TYPE=USER,xxxxxxx,*,SYSADM) /*CE-APM ID IS SYSADM
Once the line has been added to the IDB2 Security file, refresh it by either issuing the 'SECURITY' command in IDB2 or by bouncing the IDB2 data collector.