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:

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-database-management-solutions-for-db2-for-z-os/20/using/use-thread-termination-dynamic-dsnzparm/maintain-db2-parameters/modify-db2-parameters-online/db2-additional-parameters.html

 

Additional Information

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-database-management-solutions-for-db2-for-z-os/20/using/use-thread-termination-dynamic-dsnzparm/maintain-db2-parameters/modify-db2-parameters-online/db2-additional-parameters.html