|
Problem IT41658
|
Status: Closed |
NOT GETTING OUTPUT WHEN EXECUTING COMPRESSION ON A FRAGMENTED TABLE, WHEREAS GETTING RESULT ON THE FRAGMENT OF THE TABLE(ROW)
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
When running the estimate_compression for a fragmented table, we
do not see the actual results -
EXECUTE FUNCTION task("table estimate_compression", "student",
"rock", "abc");
(expression) est curr change partnum coloff table/index
----- ----- ------ ---------- -----
---------------------------
Succeeded: table estimate_compression
rock:abc.student
1 row(s) retrieved.
However, If we ran estimate_compression for a fragment of the
same table, we see the expected output:
EXECUTE FUNCTION task("fragment estimate_compression",
"5242577");
(expression) est curr change partnum coloff table/index
----- ----- ------ ---------- -----
---------------------------
85.4% 84.3% +1.0 0x00500061 -1
rock:"abc".student
Succeeded: admin_fragment_command('fragment
estimate_compression
','5242577') |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC9W1. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC9W1. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC9W1. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC9W1. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC9W1. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.08.2022
17.02.2023
17.02.2023 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
