DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

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.

Disable AUTO_STATS_PROF and AUTO_PROF_UPD.

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
 

The complete fix for this problem first appears in DB2 UDB 
Version 9.7 FixPak 1.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

30.09.2009
15.12.2009
15.12.2009

9.7.