![[ Informix Logo ]](/_borders/inflogo1.gif) |
Архив интересных статей по Informix |
Пересылка: Need Help about Page Cleaner Time Out
>Hi All-
>
>I am running Informix 5.10 on Solaris 2.6.
>I created new instance and while loading data with either
>dbimport or tbload my informix log shows that
>
>15:31:04 On-Line Mode
>15:54:26 ERROR: page cleaner # 2 has timed out
>15:56:19 ERROR: page cleaner # 3 has timed out
>15:58:13 ERROR: page cleaner # 4 has timed out
>15:59:58 Checkpoint Completed
>16:05:30 ERROR: page cleaner # 5 has timed out
>16:07:25 ERROR: page cleaner # 6 has timed out
>16:09:20 ERROR: page cleaner # 1 has timed out
>16:11:20 ERROR: page cleaner # 0 has timed out
>17:27:29 Checkpoint Completed
>
>my configuration for page cleaner are
>
>CLEANERS 7 # Number of page-cleaner processes
>SHMBASE 0x10000000 # Shared memory base address
>CKPTINTVL 300 # Checkpoint interval (in seconds)
>LRUS 8 # Number of LRU queues
>LRU_MAX_DIRTY 60 # LRU modified begin-cleaning limit
>(percent)
>LRU_MIN_DIRTY 50 # LRU modified end-cleaning limit
>(percent)
>
>My question is that above ERROR messages for page cleaner do I have to
>worry about or not.
>
>Thanks in advance,
>
>--
>===============================================================
>Umesh Patel
>On Assignment with Caliber Logistics-
>===============================================================
>
>
>
>
>As you are doing a load, there are too much work to be done by the
>cleaners, they try to clean the dirty pages but the load generates more
>work and so the cleaners couldn't clean a LRU at the specified time (2
>min).
>
>To avoid it you could issue checkpoints more often when you are making a
>load.
>
>But anyway after the load if the Cleaners timeout you should bring them
>back to work againg by taking the instance down and up again,
>
>--
>
>Ricardo Palmeira
>Tribunal de Contas do Estado de Pernambuco
>mailto:palmeira@tce.pe.gov.br
>
| [ Home ] |
Сайт создан при поддержке Украинского
представительства Informix Software Inc. |
Hosted by ANTEC |