The XNET IDB2 interface fails with REQUEST IDB2:DSQTHD FAILED - RC 197 RSN 24
Article ID: 130485
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA 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),