PDTBATCH RECEIVES PDT0220 FOLLOWED BY SQL -923 in XMANAGER LOG

Document ID : KB000007404
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

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.