Is it possible to access the Thread Terminator log information from a file or register to generate reports

Products

• Thread Terminator for DB2 for z/OS

Issue/Introduction

Is it possible to access the Thread Terminator for Db2 for z/OS (PTT) log information from a file or register to generate reports.

Resolution

The PTT log is the only place that cancelled thread information is written. (unless the thread is cancelled using the PTTBATCH job. In that case, it is also written to the Thread Termination Report). 

Possible workarounds: 
1) A dataset (RECFM FB, LRECL= 154) can be allocated to the PTTLOG DD statement in the Xmanager JCL, to place the TT Log information in a dataset 
2) Use the Sysview "X" command on the PTTLOG DD statement of your Xmanager, to copy the Sysview Xmanager Log information to a dataset