Remote PKLIST entries missing in BIND and REBIND statements generated in Plan Analyzer for Db2 for z/OS
Article ID: 392907
Updated On:
Products
Issue/Introduction
Plan Analyzer for Db2 for z/OS (PPA) excludes remote packages from the PKLIST when generating BIND and REBIND statements.
Resolution
In order to enable remote package processing in PPA, the PPA profile option 'Process Remote Packages' must be set to Y as shown below in bold:
--------------- PPA Profile Variables -------------- 2025/04/02 11:24
General Execution Parameters:
Qualifier ON/OFF default ===> N (Y=ON or N=OFF)
Explode SQL ON/OFF default ===> Y (Y=Exploded or N=Shrunk)
Strategy List Mode default ===> L (L=List vers or N=Do not list vers)
Expert Mode default ===> Y (Y=Expert, N=Regular)
Display Batch Processor Input
Screen default ===> Y (Y or N)
Package version(s) default ===> A (A=All, L=Latest version)
Package versioning method ===> N (N=None, A=Auto, O=Creation)
Package replace version default ===> Y (Y or N)
Host Language default ===> ASM (ASM, COB, PLI, C, or SPF)
Update Statistics Qualifier ===> SYSIBM
Process Remote Packages ===> Y (Y or N)
Floating Point Format ===> SCI (SCI, ENG, or MET)
Use New Report Layouts ===> Y (Y or N)
Use Stored Proc. for Explain ===> N (Y or N)
Package Copies Display ===> N (Y=Show copies,N=Do not show copies)
Suppress Expl Prof Select panel ===> N (Y=Suppress, N=Do not suppress)
Using the PPPDDF variable in the PPA member of hlq.CDBAPARM will not work. For PPA contents in hlq.CDBAPARM, many of these variables like PPPDDF are one time use and are populated into user ISPF profile on first use of the product. If you desire to modify the value for PPPDDF (Process Remote Packages) then it must be changed via the PPA profile option from the Plan Analyzer Main Menu using path:
PF Profile
2 - PPA Profile Variables
Process Remote Packages ===> Y (Y or N)
Feedback
