|
Problem IC62332
|
Status: Closed |
SQL2314W WHEN RUNSTATS ON TABLE WITH WRITE ACCESS AND LOW INSERT/UPDATE ACTIVITY. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL. *
****************************************************************
* PROBLEM DESCRIPTION: *
* SQL2314W when runstats on table with write access and low *
* insert/update activity. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.1FP9. *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC62804 IC62805
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.08.2009
06.05.2010
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
