|
Problem IC63294
|
Status: Closed |
BYTES SAVED OUTPUT IN DB2PD -TEMPTABLE MAY BE INCORRECT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The "Total Bytes Saved" output from "db2pd -temptable" command
may display a value that may be lower than the true value if
previous workloads have performed sorts on the table. This
problem occurs because some sorts do not increase the "Total
Bytes Saved" value as much as it should. Note that db2pd will
never overestimate this value, so you can be sure that bytes
saved will always be at least the value shown. This issue
pertains solely to monitoring temporary table
compression, not to temporary table compression itself. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 v9.7 GA systems on all Linux, Unix, and Windows *
* platforms with temporary table compression enabled. *
****************************************************************
* PROBLEM DESCRIPTION: *
* The "Total Bytes Saved" output from "db2pd -temptable" *
* command may display a value may be lower than the true value *
* if previous workloads have performed sorts on the table. *
* This problem occurs because some sorts do not increase the *
* "Total Bytes Saved" value as much as it should. Note that *
* db2pd will never overestimate this value, so you can be sure *
* that bytes saved will always be at least the value shown. *
* This issue pertains solely to monitoring temporary table *
* compression not to temporary table compression itself. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 Fix Pack 1. *
**************************************************************** |
| Local Fix: |
wsdbu00539760 |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
Treat "Total Bytes Saved" output as a lower bound estimate for
temporary table compression savings. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.09.2009
20.10.2009
20.10.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
