Why Detector Standard Table Query values do not match values on the Planname Summary Display

Products

• Detector for DB2 for z/OS

Issue/Introduction

Why Detector for Db2 for z/OS (PDT) Standard Table Query values do not match the values on the Planname Summary Display.

Resolution

To match the values in the Detector Standard Activity display with an SQL Query, the corresponding RECTYPE value must be used. In the case of the Planname Summary Display the needed RECTYPE statement is:

RECTYPE=PLAN

The Grid below displays the other valid RECTYPEs and their corresponding screens:

RECTYPE SCREEN

PLAN  Planname Summary Display (Neither of the INDB2 values need to be manipulated)

PGM   Plan Program Display  

STMT  Plan SQL Display

PKGE  Package/DBRM Summary Display

PKGP  Package/DBRM Plan Display

PKGS  Package/DBRM SQL Display

DYNS  Plan Dynamic SQL Summary Display or Pgm Dynamic SQL Summary Display

Additional Information

Displays and RECTYPEs

Displays and Equivalent SQL Query Examples