IT39156: HEAVY SYSPROCPLAN LOGICAL LOG ACTIVITY AFTER UPDATING STATS FOR TABLES IN A PROCEDURE OR FUNCTION

APAR status

• Closed as program error.

Error description

• After upgrading from to 14.10.FC6 there have been occurrences of
  heavy logical log
  activity when executing prepared procedures.  The logical log
  activity begins after
  running update stats against tables within the procedure.  This
  problem was first
  observed by customers after the aus_refresh_stats sysadmin task
  was executed but
  my attached repro does not require sysadmin and reproduces by
  running update
  stats on relevant tables.
  
  This problem does not reproduce in 14.10.FC5
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 14.10.xC8.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 14.10.xC8.                        *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC8.
  

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