| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC84414 | Status: Geschlossen |
ADMIN_MOVE_TABLE TAKES LONG TIME FOR SAMPLE CREATION WHEN COMPRESSION IS ENABLED FOR TABLE. | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problembeschreibung: | |
When Admin_move_table is run with COPY option for a
compressed enabled table, the performance of this
admin_move_table application is very slow.
Here is an exmaple of the command:
call
SYSPROC.ADMIN_MOVE_TABLE('SAPR3','VBFA','','','','','','','','CO
PY_WITH_INDEXES','COPY')
Performance issue is encountered when table compression is
enabled and a COPY is performed.
Following things occur for this:
- a table has compression enabled
- a Bernoulli sampling of the data from the source table is
inserted into the target table
- the compression dictionary is then created based of this
random sample using db2Inspect
----------------
The Bernoulli sampling is very slow here causing the performance
problem of the application.
This APAR will replace TABLESAMPLE BERNOULLI with TABLESAMPLE
SYSTEM to improve the performance and hence the performance of
the ADMIN_MOVE_TABLE is improved. | |
| Problem-Zusammenfassung: | |
USERS AFFECTED: All Problem Description: ADMIN_MOVE_TABLE TAKES LONG TIME FOR SAMPLE CREATION WHEN COMPRESSION IS ENABLED FOR TABLE. Problem Summary: ADMIN_MOVE_TABLE TAKES LONG TIME FOR SAMPLE CREATION WHEN COMPRESSION IS ENABLED FOR TABLE. | |
| Local-Fix: | |
N/A. | |
| verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
| Lösung | |
Fixed in db2_v101fp1 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.06.2012 02.11.2012 02.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 10.1.0.1 |
|
| 10.5.0.1 |
|