Why are Db2 native SQL stored procedures not being captured within the Detector for Db2 for z/OS collections

Products

• Detector for DB2 for z/OS

Issue/Introduction

It was noted that Db2 native SQL stored procedures are not captured within a Detector for Db2 for z/OS (PDT) collection.
What would cause Db2 native SQL stored procedures not to be captured by PDT?

Resolution

In order for Db2 native SQL stored procedure activity to be collected by Detector  either of the following options must be enabled:

1. If you start the Detector collection using Option 5 from the 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".
   
   
2. If you start the Detector collection using MVS Modify commands the TRG parameter must be set to (Y).