PM53327: MINIMIZE DYNAMIC SQL STATEMENT CALLS WITH LITERALS FROM ADMIN_INFO_SYSLOG CALLS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Minimize dynamic SQL statement calls with literals from
  ADMIN_INFO_SYSLOG calls
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
  *                 users of the DB2 stored procedure            *
  *                 SYSPROC.ADMIN_INFO_SYSLOG                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: SYSPROC.ADMIN_INFO_SYSLOG is flooding   *
  *                      the dynamic statement cache with SQL    *
  *                      statements invoking DB2 functions       *
  *                      like TIME, HOUR, MINUTE, SECOND,        *
  *                      DATE, YEAR, MONTH, DAY, and DAYOFYEAR   *
  *                      when it is called repeatedly.           *
  *                                                              *
  *                      Sample SQL statements flooding the      *
  *                      dynamic statement cache:                *
  *                        SELECT (TIME('08.15.14')              *
  *                                - TIME('08.15.14'))           *
  *                               FROM SYSIBM.SYSDUMMY1          *
  *                        SELECT (HOUR('08.15.14'))             *
  *                               FROM SYSIBM.SYSDUMMY1          *
  *                        SELECT (MINUTE('08.15.14'))           *
  *                               FROM SYSIBM.SYSDUMMY1          *
  *                        SELECT (SECOND('08.15.14'))           *
  *                               FROM SYSIBM.SYSDUMMY1          *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  SYSPROC.ADMIN_INFO_SYSLOG issues dynamic SQL statements
  invoking DB2 datetime-related functions to validate the
  START_DATE, START_TIME, END_DATE, and END_TIME input
  parameters and to extract the different parts of these DATE
  and TIME values. When the stored procedure is called
  repeatedly, these SQL statements flood the dynamic statement
  cache.
  

Problem conclusion

• SYSPROC.ADMIN_INFO_SYSLOG is modified to replace all dynamic
  SQL calls to DB2 datetime-related functions with REXX
  instructions and functions.
  

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:

  UK77705 UK77706

Modules/Macros

• DSNADMIL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK77705

     UP12/04/24 P F204

• R910 PSY UK77706

     UP12/04/24 P F204

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.