A fix is available
APAR status
Closed as program error.
Error description
RTS misses an index access code path during the insert operation (some kind of index access "shortcut" between DM and IM). As a consequence the LASTUSED column is not being updated.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS * * users. * **************************************************************** * PROBLEM DESCRIPTION: LASTUSED in SYSIBM.SYSINDEXSPACESTATS * * is not being updated when an index is * * used to enforce a referential integrity * * constraint. * **************************************************************** * RECOMMENDATION: APPLY PTF. * **************************************************************** In case an index is used to enforce a referential integrity constraint, the index access should be reflected in the SYSIBM.SYSINDEXSPACESTATS.LASTUSED column.
Problem conclusion
Real-time statistics logic for LASTUSED was changed.
Temporary fix
Comments
APAR Information
APAR number
PM55116
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-28
Closed date
2012-03-11
Last modified date
2012-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK76968 UK76969
Modules/Macros
DSNIRELI
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 April 2012