IBM Support

IC77788: The LASTUSED column in SYSCAT.PACKAGES may not be updated for each use of a package within a connection.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The LASTUSED column in SYSCAT.PACKAGES reports the date when any
    statement in the package was last executed. The LASTUSED value
    may not be updated properly when statements in the package are
    executed more than once over the same connection. In this
    situation only the first statement executed in the package (i.e.
    the first use of the package) over the connection will result in
    the LASTUSED column being updated. Subsequent executions of
    statements in the package over the connection may not result in
    the LASTUSED value being updated.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All platform                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See APAR Description                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.7 FP5.                                         *
    ****************************************************************
    

Problem conclusion

  • V9.7 FP5 should contain the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77788

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-27

  • Closed date

    2011-12-22

  • Last modified date

    2011-12-22

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 December 2011