APAR status
Closed as program error.
Error description
When the onconfig parameter LOG_INDEX_BUILDS is enabled an index that is created on the primary server is transferred to secondary servers as a sequence of index pages in the logical logs. The algorithm used to transfer the index pages breaks down the operation into a series of transactions sized so that each transaction does not consume more than about half of the index pages specified by the LTXHWM onconfig parameter. This is designed to avoid a long transaction scenario. However, where the server has a very large amount of log space, limitations of this calculation may result in an incorrect determination of the log space used by each transaction with the result that no new transaction is started. For large indexes this may result in a long transaction which does not get rolled back and may eventually block the server. An index that occupies more than 2m pages on a 2k page size server (1m on a 4k page size instance) is vulnerable if this size represents more than 10% of the index space represented by the LTXHWM onconfig parameter.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users using index paged logging functionality. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-11.70.xC8 * ****************************************************************
Problem conclusion
Problem Fixed In IDS-11.70.xC8
Temporary fix
Comments
APAR Information
APAR number
IC97611
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-11-12
Closed date
2014-02-26
Last modified date
2014-02-26
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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
26 February 2014