home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT39156 Status: Closed

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

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem 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
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.                        *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC8.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC8.                        *
****************************************************************
Comment
Fixed in Informix Server 14.10.xC8.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.11.2021
07.04.2022
07.04.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)