Filter Options For Thread Activity Displays

Use this panel to save filter criteria to a specified profile, to activate a different profile, or to specify filter criteria that you want to use in the thread activity panels for the remainder of the session. You can use these filtering options together with the thread commands. If more than one parameter is specified, the requests are connected using a logical AND operator. To specify a reset, type character R in column 1 in front of THFL.

Note: You cannot use filtering criteria for the Utility panel (option: H-UTILITY).

To view this panel select option J on a thread activity panel such asThreads Summary Excluding Idle Threads. The content of this panel is identical to panel Filter Options For Thread Activity Displays.

 ________________ ZFILT    VTM     O2       V540.#P DA41 11/05/13 13:27:25   2  
> Help PF1     Back PF3                                                         
> T.J                                                                           
>         Thread Activity:  Enter a selection letter on the top line.           
                                                                                
> A-All-Idle    B-TSO      C-CICS      D-IMS     E-Background   F-Dist Allied   
> G-Dist DBAC   H-Util     I-Inact     *-Filter  K-Functions    L-Stored Proc   
> M-Triggers    N-Sysplex  O-Enclaves  P-Worksta Q-All+Idle                     
=============================================================================== 
>              Filter Options For Thread Activity Displays                      
> To save filters in the user profile remove the > from the PPRF command and    
> optionally add a 2 character profile suffix. Use IPRF for install profile     
>PPRF SAVE                                                                      
> To change profiles remove the > from the CPRF command and enter the 2         
> character suffix. Use CPFI to switch to installation profile                  
>CPRF xx                                                                        
 THFL                                                                           
+                                                                               
+ Specify the values to be used as filtering criteria for Thread                
+ Activity displays. Wildcard values * (multiple characters) or                 
+ ? (single character) may be specified for character values.                   
+                                                                               
+ Specify the following filters to be applied within DB2                        
+                                                                               
: PLAN             =  ________            (plan name)                           
: AUTHID           =  ________            (authorization id)                    
: CONNID           =  ________            (connection id)                       
: LOCATION         =  ________________    (location)                            
: PARENTACE        =  ________            (parent ace for parallel tasks)       
: CORRID           =  ____________        (correlation id)                      
: ENDUSERID        =  ________________                   (end user id)          
: WORKSTATION      =  __________________                 (workstation)          
: TRANSACTIONID    =  ________________________________   (transaction id)       
+ Specify the following filters to be applied within OMEGAMON                   
+                                                                               
: PACKAGE/DBRM     =  ________            (name      )                          
: COLLECTION       =  __________________  (collect id)                          
: DB2STAT          =  ____________        (db2 status)                          
: GETPAGES         >  _________           (number of getpages)                  
: UPDATES          >  _________           (number of page updates)              
: COMMITS          >  _________           (number of commits)                   
: ELAPTIME         >  _________           (elapsed time - in seconds)           
: ELAPTIME/COMMIT  >  _________           (elapsed time per commit)             
: DB2TIME          >  _________           (In DB2 time - in seconds)            
: DB2TIME/COMMIT   >  _________           (In DB2 time per commit)              
: PROCESSINGINDB2  =  ___                 (Status Active in DB2)                
: THREADLIM        =  _________           (Limit on number of threads returned) 
===============================================================================

Shortcut to specify filter criteria on thread activity panels

If you already know the available filter criteria, you can bypass the Filter Options panel and enter the criteria directly on any thread activity panel. The following example shows a partial Threads Summary Excluding Idle Threads panel. The criteria (here: PLAN¬=KO2PLAN) is entered on the "command line" following the (panel-specific) identifier THDA. To remove the criteria, overtype them with space characters and press Enter.

Note the status information about filtering and the profile in use.

 
________________ ZALLT    VTM     O2       V540.#P SC11 S 07/07/16 14:27:48 2  
> Help PF1      Back PF3       Up PF7      Down PF8     Sort PF10    Zoom PF11  
> T.A                                                                           
>         Thread Activity:  Enter a selection letter on the top line.           

> *-All-Idle    B-TSO      C-CICS      D-IMS     E-Background   F-Dist Allied   
> G-Dist DBAC   H-Util     I-Inact     J-Filter  K-Functions    L-Stored Proc   
> M-Triggers    N-Sysplex  O-Enclaves  P-Worksta Q-All+Idle                     
=============================================================================== 
>                    Threads Summary Excluding Idle Threads                     
 THDA                                                                           
+                        Filtering is active. Profile #P is in use              
+ *                                                                             
+ Elapsed      Planname  CPU    Status       GetPg  Update Commit CORRID/JOBN   
+ ----------   --------  -----  ------------ ------ ------ ------ ------------  
+ 05:02:51.2   KO2PLAN   00.0%  IN-SQL-CALL     272      4      8 OMPE051S      
+ 05:02:48.4   KO2PLAN   00.0%  NOT-IN-DB2      243      0      7 OMPE051S      
+ 05:02:30.5   KO2PLAN   00.0%  NOT-IN-DB2     7132   4375    462 OMPE051S      
+ 05:01:26.2   KO2PLAN   00.0%  NOT-IN-DB2        0      0      0 OMPE051S      
==========================================================================

Navigation

For additional information about

related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

Fields

Note: For details about operators and wildcard characters use online help F1 (Help). Most fields are only applicable for active threads.

The following fields enable OMEGAMON® XE for DB2 PE to send filters to DB2 as well as to apply "post-filtering" of data returned from DB2. These filters can improve the performance in your environment.

The following fields provide filtering within DB2:

PLAN: The DB2 plan name of the active thread. You can specify up to 8 characters.
AUTHID: The DB2 thread authorization identifier of the active thread. You can specify up to 8 characters.
CONNID: The DB2 connection identifier of the active thread. You can specify up to 8 characters.
LOCATION: The name of the location requesting information. You can specify up to 16 characters. The field will either filter on the requesting location (QW01488L, for example, for distributed database access threads), or the DB2 location (QW0148LN) if the requesting location field is not filled by DB2.
PARENTACE: The agent control element (ACE) token. Specify the parent ACE for the parallel task. You can specify up to 8 digits. A value of 0 filters out child parallel tasks from the Thread Activity displays.
CORRID: The correlation identifier. You can specify up to 12 characters. If the application requestor is a DB2 system, this is the same correlation ID assigned at the requestor. If the application requestor is not DB2, this is the name of the job, task, or process that is being serviced.
Note: This field is case sensitive. It is not converted to uppercase.
ENDUSERID: The end user's work station user ID. You can specify up to 16 characters. This can be different from the authorization ID used to connect to DB2. It contains blanks if the client does not supply this information.
Note: This field is case sensitive. It is not converted to uppercase.
WORKSTATION: The workstation identifier. You can specify up to 18 characters. It contains blanks if the client does not supply this information.
Note: This field is case sensitive. It is not converted to uppercase.
TRANSACTIONID: The name of the transaction or application that the end user is running. It identifies the application that is currently running, not the product that is used to run the application. You can specify up to 32 characters. This field contains blanks if the client does not supply this information.
Note: This field is case sensitive. It is not converted to uppercase.

The following fields enable filtering of the data returned from DB2 and are applied by OMEGAMON XE for DB2 PE:

PACKAGE/DBRM

The DB2 package name or DBRM name of the active thread. You can specify up to 8 characters.

COLLECTION

The package collection identifier of the active thread. You can specify up to 18 characters.

DB2STAT

The DB2 status. You can specify up to 12 characters. For definitions of all possible status values, see "DB2 Thread Status".

GETPAGES

The number of Getpage requests issued by the active thread since thread creation. You can specify up to 9 digits.

UPDATES

The number of DB2 page updates made by the thread since thread creation. This value is incremented each time a row in a page is updated, not just once for each page updated. DB2 might update pages when it creates intermediate result tables because of a qualified SELECT statement, even though SELECT statements are generally thought of as read only operations. Pages that have been updated are written asynchronously by DB2, according to DB2's internal Deferred Write algorithm, not immediately after update or commit. DB2 resets the page update count at Create Thread and Signon. If Signon is not driven, the page update count is cumulative. This file is applicable for active threads only. You can specify up to 9 digits.

COMMITS

The number of times the thread successfully completed commit processing. DB2 resets the commit count at thread create and signon. If signon is not driven, the count is cumulative. You can specify up to 9 digits.

ELAPTIME

The elapsed time since thread creation. You can specify up to 9 digits.

ELAPTIME/COMMIT

Average elapsed time between commits. If the number of commits is zero this field is the same as ELAPTIME. You can specify up to 9 digits.

DB2TIME

The total In-DB2 elapsed time in seconds for an active thread. You can specify up to 9 digits.

DB2TIME/COMMIT

Average In-DB2 elapsed time between commits. If the number of commits is zero this field is the same as DB2TIME. You can specify up to 9 digits.

PROCESSING-IN-DB2

Values YES, NO or blank.

YES

Only threads that are in a status that is active in DB2 are shown. If a thread is executing in the application it is not shown. The following thread statuses are processing in DB2:

IN-DB2
IN-TRIGGER
IN-COMMAND
IN-STOR-PROC
IN-USER-FUNC
IN-TERM-THRD
WAIT-LOCK
WAIT-GLBLOCK
WAIT-MSGSEND
WAIT-ARCHIVE
WAIT-REMSQL
WAIT-CONVLIM
WAIT-TERM-TH
WAIT-SP-STOP
WAIT-SP-SCHD
SP/UDF-INACT
WAIT-SYNC-IO
WAIT-SERVICE
WAIT-ASYNCRD
WAIT-ASYNCWR
WAIT-LOGQSCE
WAIT-PGLATCH
WAIT-DRNLOCK
WAIT-CLAIMER
WAIT-ARCREAD
WAIT-LOCKPIP
WAIT-LOCKPQS
WAIT-SWITCH
WAIT-ACCEL
WAIT-LOB
WAIT-COMMIT
WAIT-CL3LOCK
IN-SQL-SORT
IN-SQL-CALL
WAIT-REMREQ
IN-BIND-DYNM
IN-ACCEL
IN-AUTO-PROC

NO

Only threads that are not in an active status in DB2 are shown.

Blank

This filter is not used.

Threads accelerated by the IBM® DB2 Analytics Accelerator for z/OS® are considered as being processed in DB2.

THREADLIM

A numeric value causing OMEGAMON XE for DB2 PE to stop retrieving instrumentation records from DB2. This field can have a positive impact on realtime and system performance, but can also result in an incomplete thread list if it is less than the number of threads actually running in DB2 at the time the list is retrieved. The default setting (blank or 0) allows all records retrieved by DB2 to flow to OMEGAMON XE for DB2 PE. You can specify up to 9 digits.

Feedback