Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as duplicate of another APAR.
Error description
Add the following message to explain table in DB2 Version 9.1. Note the message text is slightly different from V8.2 version, although the explanation and user response is applicable to both. EXP0045W The table named schema.table-name has fabricated statistics. This can lead to poor cardinality and predicate filtering estimates. The size of the table changed significantly since the last time the RUNSTATS command was run. Explanation ========= Fabricating statistics means deriving or creating statistics, rather than collecting them as part of normal RUNSTATS activity. For example, the number of rows in a table can be derived from knowing the number of pages in the table, the page size, and the average row width. When a table has undergone many updates or otherwise changed significantly, the statistics cease to be valid, and you should rerun the RUNSTATS command. User response ============ Collect new statistics using the RUNSTATS command to avoid performance degradations.
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
duplicate of IZ35643
APAR Information
APAR number
IZ28167
Reported component name
DB2 EDE AIX
Reported component ID
5724N7600
Reported release
950
Status
CLOSED DUA
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-07-24
Closed date
2009-03-07
Last modified date
2009-06-12
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 EDE AIX
Fixed component ID
5724N7600
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]
Document Information
Modified date:
03 October 2021