Use Thread Termination\Dynamic DSNZPARM

Thread Termination/Dynamic DSNZPARM
 is a powerful tool for managing your Db2 subsystem. Use this tool to manage threads, the Db2 environment, and your Db2 parameters.
dm18
Thread Termination/Dynamic DSNZPARM
 is a powerful tool for managing your Db2 subsystem. Using this tool, you can manage threads, the Db2 environment, and your Db2 parameters:
  •  You can view thread information and safely terminate threads without affecting other transactions. Threads can be terminated on demand through the online panels, or in batch. You can also set up profiles that specify criteria for automatic termination of problem threads. You can also free locked tables and page sets, which is useful for ensuring that a utility or batch job can execute.
  •  You can manage your subsystem dynamically by adding and deleting active log data sets, and by adding and refreshing (or updating) exit routines.
  • You can view and alter most Db2 parameters and attributes on demand through the online panels, or in batch. You can also use the scheduler task to schedule these changes. Scheduling these updates lets you customize a subsystem for different workloads at different times of the day.
The Thread Termination\Dynamic DSNZPARM environment consists of the user interface and the Xmanager address space. The Xmanager runs as a started task and is used to establish and provide an execution environment for the product. Xmanager also provides services for carrying out most of the functions that are described here. The Xmanager task can manage all subsystems within a single MVS image and can be shared with other CA Db2 products such as 
CA Detector® for DB2 for z/OS
 and 
CA Subsystem Analyzer for DB2 for z/OS
.