Detector PDTBATCH execution receives PDT0220 followed by SQL -923 in Xmanager log

Products

• Detector for DB2 for z/OS

Issue/Introduction

Detector for Db2 for z/OS (PDT) PDTBATCH job ends with the following error message:
PDT0220 PDTQDRCC DB2=ssid REQ=CAF-OPEN SQLCODE= -923 CONNECTION NOT ESTABLISHED.

An attempt to retrieve the text for a SQL statement from the Db2 catalog failed for Db2 subsystem ssid.

Resolution

When the PTLDRIVM program in the PDTBATCH job is called without a suffix parameter, the program will look in the job PTIPARM library allocation
(hlq.CDBAPARM) for the ENVDEF member to ascertain the SUFFIX. If no ENVDEF member is found within the hlq.CDBAPARM library a default '00'
will be used as the suffix. If the PTIPARM dataset does not contain a valid PTISYS00 member to allocate the other global parmlib members
(PLANSxx, DSNAMExx, ISPFxx, SETUPxx) the PTLDRIVM program will be unable to determine the necessary Db2 information, thus the failure occurs.