Informix - Problem description
Problem IT31903 | Status: Closed |
WHEN LRU MIN/MAX VALUES ARE CONFIGURED TO VALUES < 1 ON HDR SECONDARIES THEY ARE INCORRECTLY INCREASED TO 1 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
t's easy to see this problem issue when comparing onstat -R output from the primary server to the secondary server. Example: primary onstat -R 1016 f 9985 100.0% 9984 9127 857 1017 m 0.0% 1 0 1 1018 f 9984 100.0% 9983 9113 870 1019 m 0.0% 1 0 1 1020 f 9984 100.0% 9983 9099 884 1021 m 0.0% 1 0 1 1022 f 9984 100.0% 9983 9062 921 1023 m 0.0% 1 0 1 516 dirty, 5111807 queued, 5111808 total, 8388608 hash buckets, 16384 buffer size start clean at 0.020% (of pair total) dirty, or 2 buffs dirty, stop at 0.010% secondary 1016 f 9984 99.8% 9963 9434 529 1017 m 0.2% 21 20 1 1018 f 9984 99.8% 9962 9427 535 1019 m 0.2% 22 21 1 1020 f 9984 99.7% 9951 9380 571 1021 m 0.3% 33 32 1 1022 f 9984 99.6% 9949 9379 570 1023 m 0.4% 35 34 1 14318 dirty, 5111808 queued, 5111808 total, 8388608 hash buckets, 16384 buffer size start clean at 0.020% (of pair total) dirty, or 2 buffs dirty, stop at 0.010% You can see all the above modified LRU's have > the max dirty percentage of 0.02% on the secondary. This extra dirty pages can impact performance of the primary around checkpoints. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.02.2020 04.03.2020 04.03.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC4 | |
Problem solved according to the fixlist(s) of the following version(s) |