Detector colletion optons in panel
Article ID: 113423
Updated On:
Products
Subsystem Analyzer for DB2 for z/OS
Detector 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)
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)
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)
Feedback
Yes
No
Powered by
