DB2 FOR LUW / DB2FORLUW / 910 - 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 V9.1FP9.                                          * 
****************************************************************

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.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
 

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC62804 IC62805 
Nachfolger : 

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

02.08.2009
06.05.2010
05.06.2012

9.1.FP9