The XNET IDB2 interface fails with REQUEST IDB2:DSQTHD FAILED - RC 197 RSN 24
Article ID: 130485
CA Bind Analyzer for DB2 for z/OS
CA SQL-Ease for DB2 for z/OS
CA Sysview Performance Management Option for DB2 for z/OS
CA Plan Analyzer for DB2 for z/OS
CA Subsystem Analyzer for DB2 for z/OS
A REXX API communicating with IDB2 via XNET encounters failure.
The following message is indicated in the IDB2 DC job output:
REQUEST IDB2:DSQTHD FAILED - RC 197 RSN 24
The UserID (STCGDPS) coming into IDB2 via the REXX program API was not defined in IDB2's security file
either explicitly or through a wildcard.
IDB2 r19, r20. DB2 v11,v12
Adding the UserID (STCGDPS) to the IDB2 DC's security file resolved the error condition.
This is the statement that was added in the security file: (TYPE=USER,STCGDPS,*,SYSADM),