PDTBATCH RECEIVES PDT0220 FOLLOWED BY SQL -923 in XMANAGER LOG

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

The PDTBATCH job ends with the following error message:PDT0220 PDTQDRCC DB2=DB2A 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 (DB2A).

Environment

Release:
Component: PDT

Resolution

When the PTLDRIVM program in the PDTBATCH job is called without a suffix parm, the program will look in the job's PTIPARM library allocation (.CDBAPARM) for the ENVDEF member to ascertain the SUFFIX. If no ENVDEF member is found within the 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. Please review the Implementation Guide for more information on the ENVDEF member setup.