VIEW BY KEYS

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

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

Environment

Release:
Component: PDT

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.