search cancel

Execute Thread Terminator Update DB2 Parameter commands in batch mode.

book

Article ID: 35340

calendar_today

Updated On:

Products

DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Administration 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 Thread Terminator for DB2 for z/OS

Issue/Introduction

Is there a facility to execute Thread Terminator Main Menu option Update DB2 Parameters modifications
in batch mode via the Database Management Solutions for Db2 for z/OS product suite?

 

Resolution

This is done using the Thread Term/Dynam DSNZPARM Batch Facility.


First generate sample JCL to use:

From DBM Solutions for Db2 for z/OS Post-Install Tailoring (INSMAIN) select option
2  Customize  - Execute product specific customization tasks,

Select the PTISYS Parmlib Member.....then the Product Customization screen is displayed. 

Select Product PTT:
PTT     Thread Term/Dynam DSNZPARM

Option 7 will generate sample JCL to hlq.CDBASAMP called PTTBATCH.

This JCL can then be updated with the commands required to execute in batch.


For further details reference: Modify Db2 Parameters Using Batch Job Processing