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

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/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

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