Is there any method to change the Plan Owner during the Database Management for Db2 for z/OS bind process within Post Install
search cancel

Is there any method to change the Plan Owner during the Database Management for Db2 for z/OS bind process within Post Install

book

Article ID: 10402

calendar_today

Updated On:

Products

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 DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Requirement to modify the Plan Owner in the Database Management for Db2 for z/OS Post Install tasks running the Bind process
to be a different userid from the userid that submitted the job. Some times this is necessary for security reasons.

Resolution

To run the Bind Product Packages and Plans Post Install task with a specific Plan Owner you have to update
PLANOWN parameter in hlq.CDBAPARM(SETUPxx) member and then regenerate the JCL.

Plans should be bound with this specific userid instead of the default userid that executes the Post Install tasks.

You can update the parameter directly in hlq.CDBAPARM member SETUPxx or thru Post Install tasks panels.
  
2 Global - Create/edit global PARMLIB members
Select SETUP Global and DB2 Subsystem Information
And select the member and DB2 SSID.
...
Bind Owner................> (Optional)

This is the help for this parameter.

Field: Bind Owner

Description: Enter the owner of the DB2 products' plan names.