|
Problem IC77788
|
Status: Closed |
The LASTUSED column in SYSCAT.PACKAGES may not be updated for each use of a package within a connection. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All platform *
****************************************************************
* PROBLEM DESCRIPTION: *
* See APAR Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.7 FP5. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
V9.7 FP5 should contain the fix. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.07.2011
22.12.2011
22.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
