Why Detector for Db2 for z/OS (PDT) Standard Table Query values do not match the values on the Planname Summary Display.
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:
The Grid below displays the other valid RECTYPEs and their corresponding screens:
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