VIEW BY KEYS

Document ID : KB000091868
Last Modified Date : 09/05/2018
Show Technical Document Details
Issue:
What is the advantage of turning on the views by keys on Dynamic SQL Stats ==) Y (Y/N) (Requires profile) View By Keys ==) Y (Y/N) (Requires profile)? Or should I just have dynamic SQL stats turned on. Please advise
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 (see page 63) for active collections and DASD requirements for externalized historical activity due to the increased granularity.