CONTROL OF RCQ PLANMGT VALUE
search cancel

CONTROL OF RCQ PLANMGT VALUE

book

Article ID: 244600

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

What is the process for determining the value of the plan management(PLANMGT) during the Rebind in RC Query? Is there a parameter or profile setting in the product or is the Db2 zparm checked?

 

 

 

Environment

Release : 20.0

Component : RC/Query for DB2 for z/OS

Resolution

RCQ PLANMGT value is controlled globally via DSNZPARM or applied to specific packages during REBIND processing via the  PLANMGMT option which is documented in the following link:

DB2-ADDITIONAL-PARAMETERS