Detector View By Keys advantages and usage

Products

• Detector for DB2 for z/OS

Issue/Introduction

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?

Resolution

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.