How can a Thread Terminator Monitor Profile be used to cancel threads that meet different threshold values with an "OR" condition?

book

Article ID: 36164

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Introduction: 

This document describes how a Thread Terminator Monitor Profile can be used to cancel threads that meet different threshold values with an "OR" condition.

Note: If multiple entries are entered into one Threshold Group, each threshold value within the Group must be met in order for the thread to be cancelled (an "AND" condition is constituted not an "OR" condition). 

Question: 

How can a Thread Terminator Monitor Profile be used to cancel threads that meet different threshold values with an "OR" condition?

Environment:  

Thread Terminator for DB2 for z/OS r17.0 and above.

Answer: 

An "OR" condition can be created within a Thread Terminator Monitor Profile for a SSID by creating 2 (or more) Termination Profile Groups for the DB2 Subsystem:

  1. Create a Notify Group which can be used for both Termination Profiile Group's.

  2. Create a Threshold Group to filter 1 threshold (DB2 Elapsed Time for example).

  3. Create another Threshold Group to filter a 2nd threshold (Getpages for example).

  4. After the above steps your Threshold Group List should appear similar to the following:
    r18.0  >   ------------- View Threshold Group List ------------- 09/09/08      THRESHOLD_GROUP      GETPAGES  ELAPSED_TIME  INDB2_TIME   INDB2_CPU_TIME     ---------------------   ---------   --------------  ------------   ----------------  _  ELAPSED TIME 10 SC   00000000             000010         000000                000000  _  GETPAGE 50000 THRS  00050000             000000         000000                000000  
  5. Create 2 Termination Profile Groups for the SSID to be monitored. In the example below, which cancels DISTSERV threads for SSID DBP1, one Termination Profile Group points to the Getpage Threshold Group and the other Termination Profile Group points to the DB2 Elapsed Time Threshold Group.

    r18.0  >   -------- View Termination Profile Group List -------- 09/09/08          PROFILE_GROUP        SSID   WARN_MODE    UUSERID      UDATE      UTIME            ----------------      -----   -------------  ----------  ---------   --------       _  DBP1 PROFILE 1       DBP1           Y           HAYGR01    09/04/09   10:40:56       _  DBP1 PROFILE 2       DBP1           Y           HAYGR01    09/04/09   11:01:11   
    Below are the DBP1 Termination Profiles:
    r18.0  ---------------- View Termination Profile --------------- 09/09/08   Termination Profile Grp ==> DBP1 PROFILE 1                                .                                                                         .                                                                         Planname        ==> DISTSERV                                              .                                                                         Threshold Group Name ==> ELAPSED TIME 10 SC                               Notify Group Name    ==> NTFY GROUP HIISD4                                  r18.0  ---------------- View Termination Profile --------------- 09/09/08   Termination Profile Grp ==> DBP1 PROFILE 2                                .                                                                         .                                                                         Planname        ==> DISTSERV                                              .                                                                         Threshold Group Name ==> GETPAGE 50000 THRS                               Notify Group Name    ==> NTFY GROUP HIISD4
  6. Start the CA Thread Terminator Monitor using the Thread Terminator Profile.

 

Environment

Release:
Component: PTT