| Latest versions | 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 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC84414 | Status: Closed |
ADMIN_MOVE_TABLE TAKES LONG TIME FOR SAMPLE CREATION WHEN COMPRESSION IS ENABLED FOR TABLE. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
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 Summary: | |
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. | |
| available fix packs: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
| Solution | |
Fixed in db2_v101fp1 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.06.2012 02.11.2012 02.11.2012 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.1 |
|
| 10.5.0.1 |
|