All of a sudden long checkpoint started

Posted in 2004

Topics: Logging & Checkpoints, Platform-Specific Issues

Vineet Mehrotra — Mon, 05 Jan 2004 16:21:30 — source: IIUG Forums & Mailing Lists

Can someone give any pointers what to look for and where to look for long checkpoint duration? Actually we have two production servers and past week all of a sudden there is an increase in checkpoint duration on both the servers simultaneously. Not sure what is going on and what might be causing this? Here are the information OS: HP-UX 11.0 Informix Dyamic Server 7.31UD2R1 Buffers 600000 LRU MIN DIRTY 1 LRU MAX DIRTY 2 04:34:17 Checkpoint Completed: duration was 14 seconds. 04:49:45 Checkpoint Completed: duration was 19 seconds. 05:05:25 Checkpoint Completed: duration was 30 seconds. 05:21:14 Checkpoint Completed: duration was 40 seconds. 05:36:40 Checkpoint Completed: duration was 18 seconds. 05:52:07 Checkpoint Completed: duration was 17 seconds. 06:07:46 Checkpoint Completed: duration was 30 seconds. 06:23:15 Checkpoint Completed: duration was 21 seconds. 06:38:44 Checkpoint Completed: duration was 19 seconds. 06:54:08 Checkpoint Completed: duration was 16 seconds. 07:09:36 Checkpoint Completed: duration was 18 seconds. 07:25:01 Checkpoint Completed: duration was 16 seconds. 07:40:27 Checkpoint Completed: duration was 18 seconds. 07:55:54 Checkpoint Completed: duration was 18 seconds. 08:11:25 Checkpoint Completed: duration was 22 seconds. 08:26:59 Checkpoint Completed: duration was 24 seconds. 08:42:41 Checkpoint Completed: duration was 34 seconds. 08:58:20 Checkpoint Completed: duration was 30 seconds. 09:13:56 Checkpoint Completed: duration was 27 seconds. 09:29:28 Checkpoint Completed: duration was 22 seconds. __________________________________ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003

↪ replying to Vineet Mehrotra

Mark Scranton — Mon, 05 Jan 2004 17:58:42 — source: IIUG Forums & Mailing Lists

--0__=08BBE481DFF103118f9e8a93df938690918c08BBE481DFF10311 Content-type: multipart/alternative; Boundary="1__=08BBE481DFF103118f9e8a93df938690918c08BBE481DFF10311" --1__=08BBE481DFF103118f9e8a93df938690918c08BBE481DFF10311 Content-type: text/plain; charset=US-ASCII How many LRUS? Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Office: 303-773-5067 Cell: 303-929-0914 email: mscranto@us.ibm.com "Vineet Mehr...." <vin_us@yahoo.com To: > cc: Sent by: Subject: All of a sudden long checkpoint started [2409] forum.subscriber@ iiug.org 01/05/2004 09:21 AM Can someone give any pointers what to look for and where to look for long checkpoint duration? Actually we have two production servers and past week all of a sudden there is an increase in checkpoint duration on both the servers simultaneously. Not sure what is going on and what might be causing this? Here are the information OS: HP-UX 11.0 Informix Dyamic Server 7.31UD2R1 Buffers 600000 LRU MIN DIRTY 1 LRU MAX DIRTY 2 04:34:17 Checkpoint Completed: duration was 14 seconds. 04:49:45 Checkpoint Completed: duration was 19 seconds. 05:05:25 Checkpoint Completed: duration was 30 seconds. 05:21:14 Checkpoint Completed: duration was 40 seconds. 05:36:40 Checkpoint Completed: duration was 18 seconds. 05:52:07 Checkpoint Completed: duration was 17 seconds. 06:07:46 Checkpoint Completed: duration was 30 seconds. 06:23:15 Checkpoint Completed: duration was 21 seconds. 06:38:44 Checkpoint Completed: duration was 19 seconds. 06:54:08 Checkpoint Completed: duration was 16 seconds. 07:09:36 Checkpoint Completed: duration was 18 seconds. 07:25:01 Checkpoint Completed: duration was 16 seconds. 07:40:27 Checkpoint Completed: duration was 18 seconds. 07:55:54 Checkpoint Completed: duration was 18 seconds. 08:11:25 Checkpoint Completed: duration was 22 seconds. 08:26:59 Checkpoint Completed: duration was 24 seconds. 08:42:41 Checkpoint Completed: duration was 34 seconds. 08:58:20 Checkpoint Completed: duration was 30 seconds. 09:13:56 Checkpoint Completed: duration was 27 seconds. 09:29:28 Checkpoint Completed: duration was 22 seconds. __________________________________ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003 --1__=08BBE481DFF103118f9e8a93df938690918c08BBE481DFF10311 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> How many LRUS? Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Office: 303-773-5067 Cell: 303-929-0914 email: mscranto@us.ibm.com <img src="cid:10__=08BBE481DFF103118f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for "Vineet Mehr...." <vin_us@yahoo.com>">"Vineet Mehr...." <vin_us@yahoo.com> <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=08BBE481DFF103118f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=08BBE481DFF103118f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=08BBE481DFF103118f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>"Vineet Mehr...." <vin_us@yahoo.com> Sent by: forum.subscriber@iiug.org 01/05/2004 09:21 AM</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=08BBE481DFF103118f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: cc: Subject: All of a sudden long checkpoint started [2409]</td></tr> </table> <tt>Can someone give any pointers what to look for and where to look for long checkpoint duration? Actually we have two production servers and past week all of a sudden there is an increase in checkpoint duration on both the servers simultaneously. Not sure what is going on and what might be causing this? Here are the information OS: HP-UX 11.0 Informix Dyamic Server 7.31UD2R1 Buffers 600000 LRU MIN DIRTY 1 LRU MAX DIRTY 2 04:34:17  Checkpoint Completed:  duration was 14 seconds. 04:49:45  Checkpoint Completed:  duration was 19 seconds. 05:05:25  Checkpoint Completed:  duration was 30 seconds. 05:21:14  Checkpoint Completed:  duration was 40 seconds. 05:36:40  Checkpoint Completed:  duration was 18 seconds. 05:52:07  Checkpoint Completed:  duration was 17 seconds. 06:07:46  Checkpoint Completed:  duration was 30 seconds. 06:23:15  Checkpoint Completed:  duration was 21 seconds. 06:38:44  Checkpoint Completed:  duration was 19 seconds. 06:54:08  Checkpoint Completed:  duration was 16 seconds. 07:09:36  Checkpoint Completed:  duration was 18 seconds. 07:25:01  Checkpoint Completed:  duration was 16 seconds. 07:40:27  Checkpoint Completed:  duration was 18 seconds. 07:55:54  Checkpoint Completed:  duration was 18 seconds. 08:11:25  Checkpoint Completed:  duration was 22 seconds. 08:26:59  Checkpoint Completed:  duration was 24 seconds. 08:42:41  Checkpoint Completed:  duration was 34 seconds. 08:58:20  Checkpoint Completed:  duration was 30 seconds. 09:13:56  Checkpoint Completed:  duration was 27 seconds. 09:29:28  Checkpoint Completed:  duration was 22 seconds. __________________________________ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 </tt><tt><a href="http://search.yahoo.com/top2003">http://search.yahoo.com/top2003</a></tt><; tt> </tt> </body></html> --1__=08BBE481DFF103118f9e8a93df938690918c08BBE481DFF10311-- --0__=08BBE481DFF103118f9e8a93df938690918c08BBE481DFF10311 Content-type: image/gif; name=

Glossary

checkpoint