|
Problem IC63440
|
Status: Closed |
SQL2025N WHEN STATISTICS PROFILE FEATURE IS ENABLED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When statistics profile is enabled, you might see the following
error intermittently:
SQL2025 : An IO error occured "accessing a file used for
collecting the
explain snapshot information occured on" on media "".
Please be aware that:
Statistics profile generation is best suited to environments
running large complex queries that apply many predicates, often
having correlations in the data of the predicate columns, and
joining and grouping over several tables. It is less suitable to
environments with a primarily transactional workload.
The fix is to ignore the error, let query continue and complete
normally and have a warning psted into db2diag.log saying that
that auto stats profile was ignored for this query. |
| Problem Summary: |
USERS AFFECTED: All using statistics profile
PROBLEM DESCRIPTION:
When statistics profile is enabled, you might see the following
error intermittently:
SQL2025 : An IO error occured "accessing a file used for
collecting the
explain snapshot information occured on" on media "".
Please be aware that:
Statistics profile generation is best suited to environments
running large complex queries that apply many predicates, often
having correlations in the data of the predicate columns, and
joining and grouping over several tables. It is less suitable to
environments with a primarily transactional workload.
The fix is to ignore the error, let query continue and complete
normally and have a warning psted into db2diag.log saying that
that auto stats profile was ignored for this query.
PROBLEM SUMMARY:
see problem description. |
| Local Fix: |
Disable AUTO_STATS_PROF and AUTO_PROF_UPD. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows
|
| Solution |
The complete fix for this problem first appears in DB2 UDB
Version 9.7 FixPak 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.09.2009
15.12.2009
15.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
