APAR status
Closed as documentation error.
Error description
The value of SEC_APPLY_POLLTIME, also considering OFF_RECVRY_THREADS and Number of CPU VPs, should not be set higher than 100, even though the DOCUMENTATION and onconfig.std recommend this for systems with more than 16 CPU VPs. If OFF_RECVRY_THREADS is set to higher than the number of CPU VPs, or even a significant proportion, together with SEC_APPLY_POLLTIME set to 1000, then the Logical Log Apply may thrash mreplay threads causing potentially significant performance degradation of Logical Log application on Secondary Servers.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Documentation prior to 14.10.xC8 release. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * **************************************************************** To set non zero value for SEC_APPLY_POLLTIME, OFF_RECVRY_THREADS onconfig value must be less than CPU VPs configured for the database server.
Problem conclusion
Fixed in Informix Server 14.10.xC8.
Temporary fix
Comments
APAR Information
APAR number
IT38594
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-10-05
Closed date
2022-04-08
Last modified date
2022-04-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]
Document Information
Modified date:
09 April 2022