|
Problem IT27475
|
Status: Geschlossen |
RTO_SERVER_RESTART DOES NOT TRIGGER CHECKPOINTS AS SHOULD TO KEEP THE ESTIMATED RECOVERY TIME CLOSE TO THE SET
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problembeschreibung: |
According to documentation checkpoints should have been
triggered by RTO to try to accomplish the setting and it shows ~
9 times the expected during ~ 20 hours and no action.
IBM Informix Dynamic Server Version 12.10.FC9X1 -- On-Line -- Up
26 days 21:31:34 -- 168610192 Kbytes
AUTO_CKPTS=On RTO_SERVER_RESTART=120 seconds Estimated
recovery time 1171 seconds
Critical Sections Physical Log
Logical Log
Clock Total Flush
Block # Ckpt Wait Long # Dirty Dskflu Total Avg
Total Avg
Interval Time Trigger LSN Time Time
Time Waits Time Time Time Buffers /Sec Pages /Sec
Pages /Sec
4490 11:47:53 *Backup 141512:0x25afd58 161.8 161.0
0.0 9 0.1 161.9 161.9 1061848 6597 644340 105
575458 94
4491 16:09:13 Plog 141601:0x14c1590 264.5 249.3
0.0 19 0.0 0.9 1.1 1255739 5038 1168631 75
1379244 88
4492 16:09:27 *User 141602:0x21273c4 14.2 10.7
0.0 23 0.0 14.0 14.2 65677 6164 83386 315
18534 70
4493 16:09:45 *User 141602:0x261b06c 8.3 2.6
0.0 19 0.0 8.4 8.4 7360 2831 7260 330
1268 57
4494 16:11:16 *User 141604:0x1f892b8 0.9 0.7
0.0 16 0.0 0.9 0.9 7067 7067 35447 358
8100 81
4495 16:13:13 *User 141605:0x28772a0 0.3 0.2
0.0 6 0.0 0.3 0.3 2540 2540 39223 332
10718 90
4496 16:15:16 *User 141607:0x270d7a8 1.2 1.1
0.0 8 0.0 1.2 1.2 2665 2429 51661 423
25430 208
4497 16:17:17 *User 141608:0x2256908 1.1 0.7
0.0 15 0.0 1.1 1.1 22812 22812 33729 278
8905 73
4498 16:20:20 *User 141611:0x1ddc4f4 0.4 0.2
0.0 11 0.0 0.3 0.4 4704 4704 75148 410
38450 210
4499 16:21:11 *User 141612:0xf225f4 0.4 0.3
0.0 6 0.0 0.4 0.4 1308 1308 19617 377
3952 76
4500 16:23:12 *User 141613:0x285aa2c 0.3 0.2
0.0 5 0.0 0.3 0.3 2877 2877 44845 370
10415 86
4501 21:47:59 Plog 141738:0x2e320cc 194.3 193.9
0.0 10 0.0 0.0 0.0 1243736 6414 1176608 60
1932285 100
4502 21:48:04 *Backup 141739:0x2f591d0 5.1 3.5
0.0 23 0.0 4.6 5.1 51332 14664 46914 240
15655 80
4503 00:36:20 Plog 141817:0x3ae71d4 222.7 218.1
0.0 18 0.0 0.6 0.7 1293763 5930 1107517 112
1212327 122
4504 02:12:30 Plog 141900:0x334db50 301.1 284.4
0.0 377 0.2 0.1 0.2 1381618 4858 971653 170
1310955 230
4505 02:55:01 Plog 141926:0x9b74bc 206.6 206.2
0.0 130 0.0 0.1 0.1 1207591 5857 1234265 466
404569 152
4506 03:25:20 Plog 141948:0x2ba1c18 144.3 144.0
0.0 81 0.0 0.0 0.0 1283052 8912 1125546 598
356510 189
4507 04:02:35 Plog 141966:0x1f87b6c 145.5 145.1
0.0 27 0.0 0.0 0.0 1208028 8323 1243186 556
285963 128
4508 06:23:12 Plog 142018:0x244fa98 249.9 249.3
0.0 8 0.0 0.0 0.0 1262495 5064 1155555 138
816029 97
4509 08:42:12 Plog 142058:0x36c7e6c 185.9 184.2
0.0 13 0.0 0.0 0.0 1571175 8530 685085 81
636503 75
Max Plog Max Llog Max Dskflush Avg Dskflush Avg
Dirty Blocked
pages/sec pages/sec Time pages/sec
pages/sec Time
9802 3362 399 6362 93
0
The physical log size is smaller than the recommended size for a
server
configured with RTO_SERVER_RESTART. Fast recovery performance
might not
be optimal. For best fast recovery performance when
RTO_SERVER_RESTART
is enabled, increase the physical log size to at least 167360758
KB.
For servers configured with a large buffer pool, this might
not be necessary. See the Administrator's Guide for more
information.
Based on the current workload, the physical log might be too
small
to accommodate the time it takes to flush the buffer pool during
checkpoint processing. The server might block transactions
during checkpoints.
If the server blocks transactions, increase the physical log
size to
at least 17016272 KB. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* RTO_SERVER_RESTART DOES NOT TRIGGER CHECKPOINTS AS SHOULD TO *
* KEEP THE ESTIMATED RECOVERY TIME CLOSE TO THE SET *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC11+. *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.12.2018
04.12.2019
04.12.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
12.10.xC11
|
| Problem behoben lt. FixList in der Version |
