The XNET IDB2 interface fails with REQUEST IDB2:DSQTHD FAILED - RC 197 RSN 24
book
Article ID: 130485
calendar_today
Updated On:
Products
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer for DB2 for z/OS
Issue/Introduction
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
Environment
IDB2 r19, r20. DB2 v11,v12
Cause
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.
Resolution
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),