Bind cards with PLANMGMT OFF when ZPARM set to EXTENDED within Plan Analyzer
search cancel

Bind cards with PLANMGMT OFF when ZPARM set to EXTENDED within Plan Analyzer

book

Article ID: 17890

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS

Issue/Introduction

Plan Analyzer for Db2 for z/OS (PPA) is generating bind cards with PLANMGMT OFF when the Zparm set to EXTENDED.
How or what controls the Plan Analyzer bind card settings?

Resolution

Plan Analyzer obtains the PLANMGT value from catalog not from the ZPARM. If you want to change the PLANMGMT settings for a package in the catalog,
the rebind options allows the package to be changed from OFF to EXTENDED for PLANMGMT. The line command to use for rebind package options is RO.