PH05288: ENABLE DB2 'STATEMENT CONCENTRATION WITH LITERALS' FEATURE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• With this APAR, QMF adds support for DB2 prepare attribute
  CONCENTRATE STATEMENTS WITH LITERALS.
  
  When activated, QMF users may be able to take advantage of DB2
  performance improvements by additional usage of the DB2 dynamic
  statement cache.
  
  Dynamic SQL statements, like those run through the QMF RUN QUERY
  command, can be eligible for optimization by DB2.
  
  The enhancement will need to be activated through the new QMF
  global variable DSQEC_CON_CSWL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V12.1 users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds new function to QMF for  *
  *                      TSO and CICS V12.1.                     *
  *                                                              *
  *                      This fix adds new QMF global variable   *
  *                      DSQEC_CON_CSWL. DSQEC_CON_CSWL          *
  *                      exploits Db2 improvements to the        *
  *                      dynamic statement cache. When dynamic   *
  *                      statement caching is active, you can    *
  *                      specify that Db2 exclude the literal    *
  *                      constants that are in dynamic SQL       *
  *                      statements when searching for a         *
  *                      statement text match in the dynamic     *
  *                      statement cache. This results in        *
  *                      more sharing and reuse of cached        *
  *                      statements.                             *
  *                                                              *
  *                      Through activation of the QMF global    *
  *                      variable DSQEC_CON_CSWL, QMF uses       *
  *                      Db2 prepare attribute CONCENTRATE       *
  *                      STATEMENTS WITH LITERALS on all         *
  *                      SELECT queries run through the RUN      *
  *                      QUERY command and all DISPLAY, EXPORT   *
  *                      and PRINT TABLE commands.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  One new global variable DSQEC_CON_CSWL is added.
  
  DSQEC_CON_CSWL (length of 1):
  
  This global variable enables the use of the
  Db2 for z/OS statement concentration with literals
  feature. It applies to dynamic SQL SELECT statements
  submitted to Db2 for z/OS through QMF commands such as
  RUN QUERY and  DISPLAY, EXPORT and PRINT TABLE. When you
  set this variable, QMF specifies support through the
  Db2 for z/OS CONCENTRATE STATEMENTS WITH LITERALS
  prepare attribute:
  
   The following values are used:
  
   0 - Do not enable Db2 for z/OS statement concentration
       with literals. This is the default.
  
   1 - Enable Db2 for z/OS statement concentration with
       literals.
  
  
   Message DSQ51248 is added to remind the user that
   the QMF data object must be reset prior to changing
   the DSQEC_CON_CSWL global variable.
  
  The QMF 12 publications have been updated with this
  information.
  

Problem conclusion

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:

  UI60108

Modules/Macros

•    DSQCGVSI DSQCRSNC DSQCSETS DSQIDOPT DSQIFSQM
  DSQIFSQS DSQIFSQV DSQIFSUM DSQIFSUS DSQIFSUV DSQIFUM2 DSQIFUS2
  DSQIFUV2 DSQJFSQM DSQJFSQS DSQJFSQV DSQJFSUM DSQJFSUS DSQJFSUV
  DSQJFUM2 DSQJFUS2 DSQJFUV2
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RC10 PSY UI60108

     UP18/12/10 P F812

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.