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?
Release: R19, R20
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.
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.
For more information about the commands available see below: