RE: Tuning Recommendations for Informix V10

"..... and trying to import a 40GB database ..." Are you doing this WITH logging or WITHOUT ? -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of dhaya.snidhi@gmail.com Sent: 20 April 2006 06:24 AM To: informix-list@iiug.org Subject: Tuning Recommendations for Informix V10 [snip] $ onstat -mYour evaluation license will expire on 2006-10-14 00:00:00 IBM Informix Dynamic Server Version 10.00.FC3R1TL -- On-Line -- Up 17:53:51 -- 271360 KbytesThu Apr 20 00:08:50 2006 00:08:50 Checkpoint Completed: duration was 496 seconds. 00:08:50 Checkpoint Completed: duration was 496 seconds. 00:08:50 Checkpoint loguniq 1, logpos 0x136b018, timestamp: 0x50bb05d 00:08:50 Maximum server connections 2 00:44:19 Checkpoint Completed: duration was 464 seconds. 00:44:19 Checkpoint loguniq 1, logpos 0x136c018, timestamp: 0x54cde4b 00:44:19 Maximum server connections 2 01:19:57 Checkpoint Completed: duration was 495 seconds. 01:19:57 Checkpoint loguniq 1, logpos 0x136d018, timestamp: 0x58e10e2 01:19:57 Maximum server connections 2 01:56:05 Checkpoint Completed: duration was 504 seconds. 01:56:05 Checkpoint loguniq 1, logpos 0x136e018, timestamp: 0x5cf4a48 01:56:05 Maximum server connections 2 02:29:30 Checkpoint Completed: duration was 836 seconds. 02:29:30 Checkpoint loguniq 1, logpos 0x1382018, timestamp: 0x61f4e08 02:29:30 Maximum server connections 2 03:11:29 Checkpoint Completed: duration was 1267 seconds. 03:11:29 Checkpoint loguniq 1, logpos 0x13dc018, timestamp: 0x65e5e2c 03:11:29 Maximum server connections 2 03:49:25 Fuzzy Checkpoint Completed: duration was 459 seconds, 9buffers not flushed. 03:49:25 Maximum server connections 2 04:21:02 Fuzzy Checkpoint Completed: duration was 346 seconds, 6buffers not flushed. 04:21:02 Checkpoint loguniq 1, logpos 0x15270d0, timestamp: 0x6ad8842 04:21:02 Maximum server connections 2 04:40:36 WARNING: Buffer pool size is too small for read aheadoperation 04:48:10 Fuzzy Checkpoint Completed: duration was 388 seconds, 9buffers not flushed. 04:48:10 Checkpoint loguniq 1, logpos 0x15c7118, timestamp: 0x700bf0d 04:48:10 Maximum server connections 2 05:21:14 Fuzzy Checkpoint Completed: duration was 316 seconds, 8buffers not flushed. 05:21:14 Checkpoint loguniq 1, logpos 0x1639100, timestamp: 0x7501b03 05:21:14 Maximum server connections 2 05:24:01 WARNING: Buffer pool size is too small for read aheadoperation 05:43:56 Fuzzy Checkpoint Completed: duration was 278 seconds, 10buffers not flushed. 05:43:56 Checkpoint loguniq 1, logpos 0x16f3130, timestamp: 0x77f5343 05:43:56 Maximum server connections 2 06:02:34 Fuzzy Checkpoint Completed: duration was 515 seconds, 4buffers not flushed. 06:02:34 Checkpoint loguniq 1, logpos 0x175b0a0, timestamp: 0x7b8191c 06:02:34 Maximum server connections 2 06:40:16 Checkpoint Completed: duration was 615 seconds. 06:40:16 Checkpoint loguniq 1, logpos 0x175c018, timestamp: 0x7e30c0d 06:40:17 Maximum server connections 2 07:09:29 Checkpoint Completed: duration was 438 seconds. 07:09:29 Checkpoint loguniq 1, logpos 0x175d018, timestamp: 0x80eced7 07:09:29 Maximum server connections 2 There seems to be a Warning with Buffer Pool Size. What change to I have to do. Also advise on the Checkpoint duration. Dhaya CB _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list > The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way. > No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd. >

I am doing this without Logging..