IT41658: NOT GETTING OUTPUT WHEN EXECUTING COMPRESSION ON A FRAGMENTED TABLE, WHEREAS GETTING RESULT ON THE FRAGMENT OF THE TABLE(ROW)

APAR status

• Closed as program error.

Error 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')
  

Local fix

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.                      *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC9W1.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels