search cancel

Detector colletion optons in panel

book

Article ID: 113423

calendar_today

Updated On:

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

Detector Options

can you point out what options in the following command correspond to the option in pdtC0001
(see below, when starting collection thru panels,
option 5) I need to know what options to select when starting collection thru panel, and want to use the same options used in the CDBAPXMP member
DYN(N) SDE(N) SQE(Y) CHV(N) SCA(Y) SQT(Y) SQLT(Y) TRG(Y) KEYS(Y) PLNX(Y) PDTC0002,---------,DETECTOR Start Collection Display,-----------,08-14-18,08:49 Command ==>, DB2 SSID,==>,D770, Specify collection options: Triggered SQL ,==>,Y, (Y/N), Plan Excl/Incl List ,==>,Y,(Y/N) SQL collection options:, Standard Activity ,==>,Y,(Y/N) , Dynamic SQL Stats ,==>,Y,(Y/N) , (Requires profile) View By Keys ,==>,Y,(Y/N) , (Requires profile) Dynamic Exceptions ,==>,N,(Y/N) , (Requires profile) Static Exceptions ,==>,N,(Y/N) , (Requires profile) SQL Errors ,==>,Y,(Y/N/A),(Requires profile) SQL Error Text ,==>,Y,(Y/N) , Host variables ,==>,N,(Y/N) , (applies to all options) Collection Profile ,==>,DETPROF_, Exception cache size MB,==>,0020,(1-20)

Environment

z/os DB2

Resolution

DYN(Y|N) Specifies whether data from dynamic SQL is collected when the SQL surpasses start a threshold specified in a profile and becomes exception SQL.
SDE(Y|N) Specifies whether data from static SQL is collected when the SQL surpasses start a threshold specified in a profile and becomes exception SQL.
SCA This option is synonymous with SQE. SCA is retained for compatibility with prior releases but can be removed in a future release.
SQE(Y|N|A|O) Specifies whether to start SQL error collection.
start CHV(Y|N) Specifies whether to start host variable collection with exception SQL data collection.
start SQT(Y|N) Specifies whether to enable more SQL text collection for SQL error data.
start SQLT(Y|N) Specifies whether to enable more SQL text collection to collect the resource statistics that are associated with dynamic SQL statements.
TRG(Y|N) Specifies whether to collect triggered SQL statistics or SQL originating from start native SQL stored procedures or native SQL user-defined functions (UDFs).
KEYS(Y|N) Collects more thread identification information to organize standard activity data by more views, such as by userid or correlation id, in addition to the standard plan hierarchy view.
start PLNX(Y|N) Specifies whether to load the plan Exclude/Include list from the specified collection profile. The plan Exclude/Include list limits CA Detector® for DB2 for z/OS monitoring to a specific set of plans that you identify. start They are all specified with a "Y" on the DETECTOR Start Collection Display See below Specify collection options: Triggered SQL ==>Y (Y/N) Plan Excl/Incl List ==>N(Y/N) SQL collection options: Standard Activity ==>Y(Y/N) Dynamic SQL Stats ==>Y(Y/N) (Requires profile) View By Keys ==>Y(Y/N) (Requires profile) Dynamic Exceptions ==>Y(Y/N) (Requires profile) Static Exceptions ==>Y(Y/N) (Requires profile) SQL Errors ==>Y(Y/N/A)(Requires profile) SQL Error Text ==>Y(Y/N) Host variables ==>Y(Y/N) (applies to all options)