It was noted that DB2 native SQL stored procedures are not captured within a CA Detector collection. What would cause DB2 native SQL stored procedures not to be captured by CA Detector?
In order for DB2 native SQL stored procedure activity to be collected by CA Detector, either of the following options must be enabled:
- If you start the CA Detector collection using Option 5 from the CA Detector Main Menu (Initialize SSID collection), the "Triggered SQL" indicator on the 2nd panel of the DETECTOR Start Collection Display must be set to "Y".
- If you start the CA Detector collection using MVS Modify commands the TRG parameter must be set to (Y).