PH37889: HOSTVARS ARE NOT COLLECTED FOR DISTRIBUTED THREADS IF PLANNAME IS NOT DISTSERV

PH37889.CQMCAE

APAR status

• Closed as program error.

Error description

• Hostvars are not collected for distributed threads if PLANNAME
  is not DISTSERV
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 Query Monitor for z/OS               *
  *                 users of component:                          *
  *                 - CQM Data Collector                         *
  *                 - Host Variables                             *
  *                 - CQM Data Offload and Batch Reporting       *
  *                 - Current Activity                           *
  *                 - Data Sharing                               *
  *                 - SQL Text                                   *
  *                 - ISPF Client                                *
  *                 - CAE server                                 *
  *                 - CAE agent                                  *
  *                 - PACKAGE VERSIONS                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Hostvars are not collected for       *
  *                      distributed threads if PLANNAME is not  *
  *                      DISTSERV.                               *
  *                      2. ABENDS378-1C in at startup resulting *
  *                       in MSG CQM1031E and MSG CQM1028E.      *
  *                      3. Cursor name may appear incorrectly   *
  *                      when looking at SQL text or SQLCA in    *
  *                      SQLCODES and Exceptions.                *
  *                      4. Empty Package version for CHILD      *
  *                      threads for static Parallel Activity.   *
  *                      5. Authorization error is raised if     *
  *                      the user restarts the CAE Server        *
  *                      and stops one of the CAE Agents.        *
  *                      6. Authorization error is appeared in   *
  *                      the CAE Alerts feature if the user      *
  *                      restarts the CAE Server and stops one   *
  *                      of the CAE Agents.                      *
  *                      7. An empty cursor is N/A in some       *
  *                      cases in Activity Browser feature.      *
  *                      8. The Buffer Pool Hit Ratio field      *
  *                      is always displayed as "0.00%" in Web   *
  *                      client since the Java 1.8 has been      *
  *                      released.                               *
  *                      9. "Couldn't get SQL text" message      *
  *                      for some threads in CAE Current         *
  *                      Activity.                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Query Monitor logic based on an assumption that distributed
  threads would have only PLANNAME = DISTSERV.
  2. ABENDS378-1C happened during Query Monitor restart
  subsequent to a prior failure to start the Query Monitor
  master address space.
  3. Residual cursor name in a control block
  not related to SQL statement exceptions.
  4. For a child thread, "Package version" should be copied from
  the original unit work. This problem only affects Current
  activity. For Summary Exceptions this issue has been fixed
  earlier. Note: For a "COMMIT" statement, the "Package Version"
  is blank.
  5. Authorization error is raised if the user restarts the CAE
  Server and stops one of the CAE Agents when in the
  Activity Browser. The Web Client then prompts the user to
  login against the stopped CAE Agent that leads to an
  authorization error.
  6. Authorization error appears in the CAE Alerts feature
  if the user restarts the CAE Server and stops one of the CAE
  Agents when in the CAE Alerts message board. The Web Client
  then prompts the user to login against the stopped CAE Agent
  that leads to an authorization error.
  7. The user can see both "N/A" and "Empty" values for
  "Cursor Name" field in Activity Browser if a cursor name is not
  specified during a program execution.
  8. Incorrect evaluation of the Buffer Pool Hit Ratio field
  due to some methods logic changes in Java 1.8.
  9. Some threads not showing SQL texts in CAE Current Activity
  in single mode or in data sharing mode in CAE and CQM ISPF.
  

Problem conclusion

• 1. Logic updated to be use published Db2 flags.
  2. Query Monitor restart logic corrected.
  3. Filtering improved to correctly populate cursor name.
  4. Algorithms were fixed.
  5. Always refresh a system select upon opening a login dialog.
  Was added an error message when client tries to connect to a
  closed CAE Agent after the CAE Server restart.
  6. A SQLTextException gets thrown if the CAE Server aren't
  able to reach the CAE Agent with the correct error message.
  7. It was decided to align the ISPF and Web Client behavior.
  Now the user will see only "N/A" value for "Cursor Name"
  field in Activity Browser if the cursor name is not specified
  during the program execution.
  8. The Java methods have been changed according to Java 1.8
  capability.
  9. Logic was changed to process SQL texts in CAE single mode,
  data sharing mode in CAE and CQM ISPF in the same way as
  single mode in CQM ISPF.
  
  Search Keywords:
  HOSTVARS CICS THREAD Package Version
  ABEND S378-1C CQM1031E CQM1028E QUERY MONITOR RESTART
  INCORROUT CURSOR_NAME CQM_SQLCODE_DET
  CQM132E Authorization error
  CAE DATASHARING CURRENT ACTIVITY SQL TEXT
  

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:

  UI77449

Modules/Macros

• CQM#ALSX CQM#BCMX CQM#CLNR CQM#CQMI CQM#CTLF CQM#DRVX CQM#ERLY
  CQM#GPRF CQM#INIX CQM#INTX CQM#IVCV CQM#IVSM CQM#MSSP CQM#PARM
  CQM#QAPI CQM#QAPX CQM#QSQL CQM#SCLV CQM#SDAQ CQM#SDIR CQM#SSMN
  CQM#STAB CQM#SWTX CQM$CALL CQM$OBJS CQM$QLCA CQM$STMT CQM$ZCMD
  CQM@LSTM CQM@WDB2 CQMBLOB  CQMCPXPT CQMEOSHV CQMISMTS CQMJAR
  CQMMACTX CQMMCALX CQMMCMDX CQMMEACX CQMMEAPX CQMMEARX CQMMEASX
  CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX
  CQMMECSX CQMMEMTX CQMMEXCX CQMMEXXX CQMMFREX CQMMFRX1 CQMMINDX
  CQMMMETX CQMMPGEX CQMMQAPX CQMMSACX CQMMSAPX CQMMSARX CQMMSASX
  CQMMSBCX CQMMSBPX CQMMSBRX CQMMSBSX CQMMSCCX CQMMSCPX CQMMSCRX
  CQMMSCSX CQMMSQLX CQMMSRCX CQMMSRVX CQMMVRFX CQMPARSE CQMQSTAT
  CQMTTGEX CQMTTXTX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI77449

     UP21/10/09 P F110

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.