|
Problem IC76670
|
Status: Geschlossen |
ERROR SQL2312N EXECUTING 'RUNSTATS INDEXES ALL' AGAINST VERY LAR GE TABLE HAVING PARTITIONED INDEXES WHICH HEAPSIZE EXCEEDS 5242 |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
Whenever the memory reservation computation for runstats local
indexes exceed 524288 pages, customers will get SQL2312N error
suggesting the new value to be set. E.g.
SQL2312N Statistics heap size is too small to carry out the
operation.
Suggested heap size is "644578" pages.
In customer scenario they have created table having 2943 range
partitions and a few partitioned indexes defined on it. They
received sql2312n when tried the following runstats command
db2 "RUNSTATS ON TABLE "CCDB"."CLAIM_COMMON" FOR INDEXES
CCDB"."NEW_IDX_NYT2" allow write access"
SQL2312N Statistics heap size is too small to carry out the
operation.
Suggested heap size is "644578" pages.
The above problem is encountered only when partitioned indexes
exist, runstats works fine on non-partitioned indexes. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users using Runstats index all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See error description above *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 FP5 or latest *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
|
| Lösung |
First fix in DB2 Version 9.7 FP 5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.05.2011
17.01.2012
17.01.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
