|
Problem IC81274
|
Status: Closed |
ADMIN_MOVE_TABLE TAKES LONG TIME FOR SAMPLE CREATION WHEN COMPRESSION IS ENABLED FOR TABLE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: |
User 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 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
|
| Solution |
Problem is fixed in Fixpak 6 for v970. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84414
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.02.2012
06.06.2012
06.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
