How to find a particular request based on field name in Sysview for Db2.
book
Article ID: 54711
calendar_today
Updated On:
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:
Review the Sysview for Db2 documentation doing a find on the word for the particular field, e.g. WAIT.
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.