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

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:

  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.