DT0220 PKGESQLT DB2=SSID PKGE=PACKAGEID REQ=PREPARE SQLCODE=805

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

Introduction: 

This document states how you can correct a "DT161E: SQL call text locate failed; validation/read error" while attempting to view SQL text on the DETECTOR SQL ERROR Summary Display.

Question: 

How can I correct the following error message "PDT0220 PKGESQLT DB2=SSID PKGE=PACKAGEID REQ=PREPARE SQLCODE=805?

Environment:  

z/OS 1.11 and above.

Answer: 

This problem can be corrected by:

1) Running the PDTSQTGR job in your <High.Level>.SOURCE library for the affected SSID

2) Recycling your Xmanager after issuing the Grants.