Detector's Dynamic SQL collection parameter not working

Products

• Subsystem Analyzer for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Detector for DB2 for z/OS
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Detector collectors initialized with parameter DYN set to Y but when a check of  CA-Detector Main Menu / 3  SSID collection status / C -Collection Information all subsystems show Dynamic SQL set to N.  Verification of HGHLVL.CDBAPXM($STRALL) for all the subsystems has DYN  set to Y. 

 

Environment

Release : 209.0

Component : CA Detector for DB2 for z/OS

Resolution

The problem is DYN(Y) and SQLT(N):

>>>

    START(DTR)DB2(DB2A)AUTO(Y)CHV(Y)DST(DETDB2A)DUR(0000)DYN(Y)EXT(Y)
    HLVL(SYSMP.CADB2)INT(0400)KEYS(N)PLEXINTV(N)PLNX(N)POOL(4000)
    PRF(DETPROFA)RND(Y)SDE(Y)SQE(Y)SQLT(N)SQT(Y)STAN(Y)TRG(N)
    PDT0500 DETECTOR COLLECTION MODIFY IN PROGRESS
    PXM0107 MODIFY TEXT =  627
    START(DTR)DB2(DB2C)AUTO(Y)CHV(Y)DST(DETDB2C)DUR(0000)DYN(Y)EXT(Y)
    HLVL(SYSMP.CADB2)INT(0400)KEYS(N)PLEXINTV(N)PLNX(N)POOL(4000)
    PRF(DETPROFC)RND(Y)SDE(Y)SQE(Y)SQLT(N)SQT(Y)STAN(Y)TRG(N)
    PDT0500 DETECTOR COLLECTION MODIFY IN PROGRESS
    PXM0107 MODIFY TEXT =  629
            START(DTR)DB2(DB2D)AUTO(Y)CHV(Y)DST(DETDB2D)DUR(0000)DYN(Y)EXT(Y)
             HLVL(SYSMP.CADB2)INT(0400)KEYS(N)PLEXINTV(N)PLNX(N)POOL(4000)
             PRF(DETPROFD)RND(Y)SDE(Y)SQE(Y)SQLT(N)SQT(Y)STAN(Y)TRG(N)
  PDT0500 DETECTOR COLLECTION MODIFY IN PROGRESS
  PXM0107 MODIFY TEXT =  631
              START(DTR)DB2(DB2E)AUTO(Y)CHV(Y)DST(DETDB2E)DUR(0000)DYN(Y)EXT(Y)
               HLVL(SYSMP.CADB2)INT(0400)KEYS(N)PLEXINTV(N)PLNX(N)POOL(4000)
                PRF(DETPROFE)RND(Y)SDE(Y)SQE(Y)SQLT(N)SQT(Y)STAN(Y)TRG(N)

>>>

DYN(Y) and SQLT(N) for all the systems.

The DYN parm is for Dynamic Exceptions (Dynamic Exceptions on the DETECTOR Start Collection Display).  The correct here for this problem is the SQLT parm which displays dynamic SQL text for Standard Activity. Set it to SQLT(Y) in the start collection modify commands, recycle  Xmanager &  should be OK.