CA Database Management for DB2 for Z/OS: Change dynam zparm in batch?

Products

• CA Database Management Solutions for DB2 for z/OS

Issue/Introduction

Is there a way by which the command(s) that would be normally executed from the CA Thread Terminator Main Menu, Update DB2 Parameters list be executed in any kind of batch mode?

Environment

Release: R19, R20
Component: PTT

Resolution

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

 

Let's first generate some sample JCL to use.

In your POST INSTALL menu for Thread Terminator (PTT) ....use option (7) to generate some sample JCL. 

  

2  Customize  - Execute product specific customization tasks

You will be asked to Select PTISYS Parmlib Member.....then the Product Customization screen is displayed. 

Select PTT. 

S PTT     Thread Term/Dynam DSNZPARM

  

there are two optional functions available to generate some sample JCL:

  

(Optional)    6. Create Sample JCL for Terminating Threads ->CDBASKL0(PTTTERM)

(Optional)    7. Create Sample JCL for Updating ZPARMS -> CDBASKL0(PTTBATCH)

   

Option 7 will generate some sample JCL to your CDBASKL0 library called PTTBATCH.

 

This JCL can then be updated with the commands that you need to run in batch. Below is an example....

 

Example: Cancel all threads accessing a Database with two tablespaces?

 

//PTTIN    DD  *

  SET DEFAULTS DB2(ssid)

  SET FREE DATABASE(dbname  ) PAGESET(psname1 ) NOSTOP

  SET FREE DATABASE(dbname  ) PAGESET(psname2 ) NOSTOP

/*

The "FREE" frees the specified page set of all users and the "NOSTOP" indicates that a STOP DATABASE PAGESET command is not issued.

SET Statement Syntax

For more information about the commands available see below:

 

Additional Information

Modify Db2 Parameters Using Batch Job Processing