DB2 - Problem description
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 | |
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 |