Cross-Enterprise APM Agent (CE-APM) not reporting any Db2 metrics from Sysview for Db2

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

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.

Cause

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.

Resolution

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.