|
Problem IT27505
|
Status: Geschlossen |
UPDATE STATISTICS HIGH FOR A TABLE USING FRAGMENT LEVEL STATISTICS MAY CONSUME EXCESSIVE MEMORY
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problembeschreibung: |
When running update statistics high for a table using fragment
level statistics and containing many fragments the amount of
memory used by the session may become very large.
For example a table defined with interval fragmentation having
620 million rows over more than 600 fragments consumed around
2.4 GB memory for a sort pool when running update statistics
high for a serial8 column.
If the table schema is altered so that fewer fragments are used
then the update statistics command will require less memory. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS 12.10.xC10 and earlier versions. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Update statistics high for a table using fragment level *
* statistics may consume excessive memory. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 24.12.2018
07.10.2019
07.10.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
12.10.xC11
|
| Problem behoben lt. FixList in der Version |
