PH35910: CQM2618I MESSAGE, TTXTW SUBTASK ABEND AND OVERLAY OF EXCEPTION AREA IF OPTKEYS(PTEXT) IS SET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CQM2618I message, TTXTW SUBTASK ABEND and overlay of exception
  area if OPTKEYS(PTEXT) is set
  

Local fix

• Turn off OPTKEYS(PTEXT)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS      *
  *                 users of component:                          *
  *                 - CQM Data Collector                         *
  *                 - SQL Text                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: CQM2618I message, TTXTW SUBTASK ABEND   *
  *                      and overlay of exception area if        *
  *                      OPTKEYS(PTEXT) is set.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  If OPTKEYS(PTEXT) is set then stripped SQL text is saved
  instead of original SQL.
  The error in calculation of stripped SQL text length could
  cause overlay of other Query Monitor areas while copying
  text.
  That overlay could be seen as CQM2618I message, TTXTW SUBTASK
  ABEND, or problem with data collection in Query Monitor.
  

Problem conclusion

• Logic was changed to correct the length calculation.
  
  Search Keywords:
  OVERLAY OPTKEYS(PTEXT) CQM2618I TTXTW SUBTASK ABEND
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• CQC#CSAL CQC#REST CQCMC1B1 CQCMC1C5 CQCMCRB1 CQCMCRC5 CQCMDLB1
  CQCMDLC5 CQCMDZB1 CQCMDZC5 CQCMINST CQCMLCB1 CQCMLCC5 CQCMLRB1
  CQCMLRC5 CQCMMFRR CQCMPRB1 CQCMPRC5 CQCMR1B1 CQCMR1C5 CQCMRRB1
  CQCMRRC5 CQCMSCLN CQCMSCLS CQCOXGBX CQCOXGC5 CQCTK1B1 CQCTK1C5
  CQCTK2B1 CQCTK2C5 CQCTK3B1 CQCTK3C5 CQCTK4B1 CQCTK4C5 CQCTK5B1
  CQCTK5C5 CQCTK6B1 CQCTK6C5 CQCTK9B1 CQCTK9C5 CQCTTEX1
  

Fix information

• Fixed component name

  COMMON COLLECTO

• Fixed component ID

  5639OLC00

Applicable component levels

• R110 PSY UI75916

     UP21/06/22 P F106

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.