Detector View By Keys advantages and usage
search cancel

Detector View By Keys advantages and usage


Article ID: 91868


Updated On:


Detector for DB2 for z/OS


What is the advantage of turning on the Detector for Db2 for z/OS (PDT) views by keys:

Dynamic SQL Stats ==) Y (Y/N) (Requires profile)
View By Keys ==) Y (Y/N) (Requires profile)

Is it better to just have dynamic SQL stats enabled?


The additional keys group lets you control what additional data should be collected and the types of Db2 connections on which the data is collected.
You can view the plans, programs, and SQL executed by a selected key such as a specific user or connection type.

Enabling additional keys collection can result in a significant increase in main storage requirements for active collections and DASD
requirements for externalized historical activity due to the increased granularity.