DB2 FOR LUW / DB2FORLUW / 970 - DB2

The value for STATISTICS_TIME column in EXPLAIN Table 
EXPLAIN_OBJECT can be truncated. 
 
Reproduction: 
 
db2sampl -xml -sql 
db2 connect to sample 
db2 -tvf C:\progra~1\IBM\sqllib_02\misc\EXPLAIN.DDL 
db2 "RUNSTATS ON TABLE DB2ADMIN.STAFF WITH DISTRIBUTION ON ALL 
COLUMNS" 
db2 "RUNSTATS ON TABLE DB2ADMIN.STAFF FOR INDEXES ALL" 
db2level 
db2 "EXPLAIN PLAN FOR SELECT * FROM DB2ADMIN.STAFF" 
 
C:\tmp>db2 "SELECT SUBSTR(TABNAME,1,40) AS NAME, STATS_TIME FROM 
SYSCAT.TABLES WHERE TABNAME ='STAFF'" 
 
NAME                                     STATS_TIME 
---------------------------------------- 
-------------------------- 
STAFF 
2011-08-11-15.26.03.456000 
 
  1 record(s) selected. 
 
 
C:\tmp>db2 "SELECT SUBSTR(OBJECT_NAME,1,40) AS NAME, 
STATISTICS_TIME FROM DB2ADMIN.EXPLAIN_OBJECT" 
 
NAME                                     STATISTICS_TIME 
---------------------------------------- 
-------------------------- 
STAFF 
2011-08-11-00.00.00.000000 
 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* THE VALUE FOR STATISTICS_TIME COLUMN IN EXPLAIN TABLE        * 
* EXPLAIN_OBJECT CAN BE TRUNCATED.                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 Fixpack 6.                               * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 v9.7 Fixpack 6. 
 
- The lack of precision in the statistics times stored in the 
packed descriptor should not have any adverse effect on general 
database operations. 
- Refresh the metadata, for example, via RUNSTATS, only if the 
incorrect stats time seen in the explain tables is something 
that you want to resolve; otherwise, let your current statistics 
collection procedure refresh the metadata over time.

keiner bekannt / siehe Local-Fix

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

15.08.2011
04.06.2012
04.06.2012

9.7.FP6