Requirement to capture Dynamic SQL within Detector for Db2 for z/OS (PDT).
There are several ways that you can capture Dynamic SQL:
----------- DETECTOR Start Collection Display ----------- 23/12/04 17:10
Command ==>
DB2 SSID ==> XXXX
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)
Collection Profile ==> XXXXXXX_ Exception cache size MB ==> 0020 (1-20)