XNET Sysview for Db2 interface fails with REQUEST IDB2 DSQTHD FAILED - RC 197 RSN 24

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

A REXX API communication with Sysview Performance Mangement Option for Db2 for z/OS (IDB2) via
XNET encounters failure. 

The following message is indicated in the IDB2 data collector job output:
REQUEST IDB2:DSQTHD FAILED - RC 197 RSN 24

Cause

The UserID (xxxxxxx) coming into IDB2 via the REXX program API was not defined in IDB2's security file either explicitly
or through a wildcard.

Resolution

Adding the UserID (xxxxxxx) to the IDB2 data collector security file resolved the error condition.
This is the statement that was added in the security file: (TYPE=USER,xxxxxxx,*,SYSADM),