DB2 FOR LUW / DB2FORLUW / 950 - DB2

Warning SQL2314W issued regarding incosistent table and index 
statistics when user running "RUNSTATS ON TABLE 
<SCHEMA.TABLE_NAME> AND INDEXES ALL WITH WRITE ACCESS" with 
concurrent insert / update activities on the table. 
Runstats would completed successfully. 
 
To verify if this scenario, you may collect db2cat result of the 
table: 
db2cat -d <dbname> -s <schema> -n <table_name> -o output_file 
 
Per each index, verify the field "Indcard" against the "No. of 
rows" of the table, if any Indcard > No. of rows, you have 
encounted this scenario.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL2314W WHEN RUNSTATS ON TABLE WITH WRITE ACCESS AND LOW    * 
* INSERT/UPDATE ACTIVITY.                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V95 FP6A                                          * 
****************************************************************

Given Runstats is successful, there is no action needed. 
To collect the most updated statistics, you may rerun the same 
Runstats command when there is no insert / update actitivites.

DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

keiner bekannt / siehe Local-Fix

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

27.08.2009
13.05.2010
05.06.2012

9.5.FP6