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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM53327

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-12-01

  • Closed date

    2012-04-05

  • Last modified date

    2012-05-02

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM53327

Modified date:

2012-05-02

Translate my page

Machine Translation

Content navigation