A fix is available
APAR status
Closed as program error.
Error description
MODIFY STATISTICS INDEX creator.ixname DELETE ALL AGE(*) deletes all entries in SYSIBM.SYSINDEXES_HIST for creator.table and not only entries from creator.ixname. Change will be, while deleting the rows from sysindexes_hist, we will specifying the index name as part of the predicate for the delete of the related history rows.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS * * users of MODIFY STATISTICS INDEX DELETE ALL * **************************************************************** * PROBLEM DESCRIPTION: MODIFY STATISTICS INDEX DELETE ALL * * deletes more records than it should * * from DB2 catalog table * * SYSIBM.SYSINDEXES_HIST * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** MODIFY STATISTICS INDEX DELETE ALL deletes from DB2 catalog table SYSIBM.SYSINDEXES_HIST all records related to the table on which the specified index is defined. MODIFY STATISTICS INDEX DELETE ALL should only delete the records that are related to the specified index. A similar problem could happen for MODIFY STATISTICS INDEXSPACE DELETE ALL.
Problem conclusion
MODIFY STATISTICS INDEX DELETE ALL and MODIFY STATISTICS INDEXSPACE DELETE ALL has been changed to only delete the records that are related to the specified index or indexspace.
Temporary fix
Comments
APAR Information
APAR number
PI33286
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-01-23
Closed date
2015-04-08
Last modified date
2015-05-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI26696 UI26697
Modules/Macros
DSNUMSTA
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 May 2020