How to find a particular request based on field name in Sysview for Db2.

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

How to locate a Sysview for Db2 for z/OS (IDB2) request that contains the information regarding a particular field e.g WAIT-TIME for ACCT Class 3.

Resolution

Steps to follow:

1. Review the Sysview for Db2 documentation doing a find on the word for the particular field, e.g. WAIT.
   
   
2. Once the specific field(e.g. Wait) is determined, then search the highlevel.TGTREQ (request libraries) library to find the Request(s) using that field.

NOTE: This procedure can be used for any field.