PH35230: ABEND0C4-4 IN CQM#SSMN+X'4FBC'

PH35230.CQMCAE
IBM Db2 Query Monitor for z/OS CAE Browser Client download

APAR status

• Closed as program error.

Error description

• This APAR addresses the following symptoms:
  - ABEND0C4-4 in CQM#SSMN+X'4FBC'
  - RACF security protection problems with exceptions for SQL
  texts and Hostvars.
  - Asterisks in SQLCODES panel may appear and disappear
  sporadically in Data Sharing mode.
  - Long SQL Text is truncated in SQL Code Summary panel in local
  view.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS      *
  *                 users of component:                          *
  *                 - Documentation - Public use                 *
  *                 - CQM Data Collector                         *
  *                 - ISPF Client                                *
  *                 - DB2 QM SQL Code Summary                    *
  *                 - CAE server                                 *
  *                 - CAE agent                                  *
  *                 - Data Sharing mode                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. ABEND0C4-4 in CQM#SSMN+X'4FBC'       *
  *                      2. No messages referring to the         *
  *                      interval dataset filled up were         *
  *                      provided either in syslog or in Query   *
  *                      Monitor started task output.            *
  *                      3. RACF security does not work          *
  *                      correctly in exceptions for SQL texts   *
  *                      and Host variables. A security issue    *
  *                      arose with DISTSERV threads or          *
  *                      dynamic SQL texts for threads with      *
  *                      DSNTEP2 plan.                           *
  *                      4. Asterisks in SQLCODES panel may      *
  *                      appear and disappear sporadically in    *
  *                      Data Sharing mode.                      *
  *                      5. Query monitor stops                  *
  *                      interval switching and Query Monitor    *
  *                      started task does not terminate after   *
  *                      STOP command was issued.                *
  *                      6. CQM075E message about insufficient   *
  *                      memory is not displayed when there is   *
  *                      not enough memory in ISPF.              *
  *                      7. Long SQL Text is truncated in SQL    *
  *                      Code Summary panel in local view.       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. If Query Monitor and Guardium S-TAP for Db2 have different
  versions of shared modules and products are recycled several
  times, an ABEND0C4-4 may occur in module CQM#SSMN+X'4FBC'.
  2. Attempt to read after the end of dataset. This situation
  can occur if during forming of interval datasets there was no
  free space in the associated files to write details while
  there still was enough free space in the main file to write
  the summary data.
  An empty screen with only the title and text of the error
  message indicates that no data was extracted from the interval
  files.
  3. When viewing the SQL texts and host variables in Exceptions,
  internal flags were incorrectly interpreted and the RACF
  interface module CQM#SIGX was not called.
  4. Misleading asterisks behavior in SQLCODES panel can be
  seen in a DSG mode when the MAX_SQLCODE_DETAILS parameter
  is set to a different value on Query Monitor
  subsystems, monitoring different Db2 DSG members.
  5. ENQ contention for CQMINTER dataset may cause a pending ENQ
  that prevents the Collector from interval switching and
  started task termination. That may happen when ISPF user
  attempts to Keep or Release an Interval while the CQMINTER
  dataset is in exclusive use of Collector or DFHSM.
  6. The CQM#QAPI module does not allow the use of the
  $SETMSG macro.
  7. For records with SQL text longer than 32K, we read the
  first record and all its segments only by key, since the KSDS
  dataset does not guarantee their sequential placement in the
  dataset.
  

Problem conclusion

• 1. Logic was changed to catch shared modules versions mismatch
  more accurately.
  2. Instead of the message CQM145E (VSAM logic error), if RC=8,
  Reason=20 is returned from reading the VSAM interval file and
  the current RBA is greater than the RBA of the end of the file,
  the message CQM179E is issued.
  3. Internal flag management improved.
  4.Logic changed to show asterisks in the SQLCODES panel only for
  local connection to Query Monitor on the current interval as
  there is currently no requirement to have the same
  MAX_SQLCODE_DETAILS parameter set on all involved Query
  Monitors and such a requirement can be impractical. With this
  change, an asterisk appears when collected detail SQLCODE
  records number reaches the MAX_SQLCODE_DETAILS limit.
  5. Logic added to ensure that every CQMINTER ENQ obtained then
  cleared up with the DEQ request.
  6. Improved the algorithm for displaying the CQM075E
  message in TSO region. If there is not enough memory,
  the CQM239E message will be used.
  7. Reading SQL texts algorithms have been fixed.
  
  Search Keywords:
  ABEND 0C4 CQM#SSMN X'4FBC' RECYCLE
  CQM145E CQM179E CQM132E CQM075E
  ASTERISK OCCURRENCES MAX_SQLCODE_DETAIL
  INTERVAL SWITCH CQMINTER ENQ
  

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:

  UI77076

Modules/Macros

• CQM#EXCP CQM#IVSM CQM#QAPI CQM#QAPX CQM#QSQL CQM#SCLV CQM#SDIR
  CQM#UINX CQM$ACTV CQM$BUFP CQM$CALL CQM$CPRF CQM$DB2C CQM$DDB2
  CQM$DELY CQM$ERRP CQM$HSTV CQM$INTD CQM$INTV CQM$LOCK CQM$OBJS
  CQM$PRFS CQM$PROF CQM$QRPT CQM$SM01 CQM$SQC2 CQM$SQC3 CQM$SQCI
  CQM$SQCM CQM15    CQM17    CQM179E  CQM@WDB2 CQMBLOB  CQMC0150
  CQMCFPAX CQMCPXPT CQMJAR   CQMMEACX CQMMEAPX CQMMEARX CQMMEASX
  CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX
  CQMMECSX CQMMEMTX CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI77076

     UP21/09/16 P F109

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.