Exception Identification Data

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Customer uses this identification DATA:

 Type: Average application "time" (CPU, elapsed, etc.) exception                           

V1: Elapsed time spent processing in DB2                     QWACASC                      

V2: # SMF type 101 records processed (1 for active threads)  FLDRECSX                     

 Is the exception to occur when the value is higher or equal to, or lower                 

 than or equal to the threshold value? . . . .  HIGH (Enter HIGH or LOW)                  

 Does exception apply to test, prod. or both? . BOTH (Enter TEST/PROD/BOTH)               

 Qualifying data (may be generically specified)                                           

   Subsystem name . FAPR  Connection name . ********  Plan name . ********                

   Conn type 10 0 All        3 CAF Online 6 IMS Trans   9 DDF Privat 12 CICS              

                1 TSO Online 4 CAF Batch  7 IMS BMPATT 10 DDF DRDA   13 Utility           

                2 TSO Batch  5 DL/I Batch 8 IMS MPPATT 11 IMS Cntrl  14 RRSAF            

For Conn type: 10  DDF DRDA   It's blocking  all the  DISTSERV plan but customer needs to exclude UTILITY arriving from other LPAR. How to do that so that he can filter CONNECT:SERVER?

 

Environment

Release:
Component: CIDB

Resolution

To filter use the connection name to identify the names wanted.