Starting a Static Exception in Detector
search cancel

Starting a Static Exception in Detector

book

Article ID: 388744

calendar_today

Updated On:

Products

Detector for DB2 for z/OS

Issue/Introduction

What is the parameter to specify on the START(DTR) command to activate Static Exception collection in Detector?

Environment

z/os DB2 Detector

Resolution

 See this option for Static SQL Exceptions

SDE(Y|N)
    Specifies whether to collect data from static SQL when the SQL surpasses the profile threshold and it becomes exception SQL:
    Y  Collects static SQL data. If you specify Y, also specify PRF and DYN(Y).
    N  Does not collect static SQL data.
    Default: N

Start Collection parameters