The XNET IDB2 interface fails with REQUEST IDB2:DSQTHD FAILED - RC 197 RSN 24

book

Article ID: 130485

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem 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 

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.

Environment

IDB2 r19, r20.  DB2 v11,v12

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),