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

book

Article ID: 50961

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

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?

Solution:

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

  1. 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".

  2. If you start the CA Detector collection using MVS Modify commands the TRG parameter must be set to (Y).

Environment

Release:
Component: PDT