CA Detector running on same system as IBM Query monitor

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Is it possible to run IBM Query Monitor and CA Detector on the same system?

Environment

Release:
Component: PDT

Resolution

The COMPAT option, which is specified in the highlvl.CDBAPARM(PDT) member, should be set to (Y). The default value is (N). Please note the explanation in PDT member:

 

COMPAT      (N)      /* Start Detector collections using an         */

                     /* alternate collection method that will allow */

                     /* Detector to run with other vendor's DB2     */

                     /* monitoring products.                        */

                     /* COMPAT (Y) should only be selected if       */

                     /* Detector has attempted to start a           */

                     /* collection and abended with a U120, or if   */

                     /* known conflicts exist between Detector      */

                     /* and other vendor's products.                */

                     /* Y - Yes, start Detector collections in      */

                     /*     third-party compatibility mode.         */

                     /* N - No, do not start Detector collections   */

                     /*     in third-party compatibility mode.      */

                     /*     display.                                */

 

It would be best to start Query Monitor first, followed by Detector, and stop them in the reverse order, but verify on a test DB2 first