The XNET IDB2 interface fails with REQUEST IDB2:DSQTHD FAILED - RC 197 RSN 24
Article ID: 130485
Bind Analyzer for DB2 for z/OS
SQL-Ease for DB2 for z/OS
SYSVIEW Performance Management Option for DB2 for z/OS
Plan Analyzer for DB2 for z/OS
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
IDB2 r19, r20. DB2 v11,v12
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.
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),