work in checkpoint time

Folks, IDs11.50 FC8 We have more work/job/volume which make checkpoint times very long ( hundreds seconds) I want to monitor which tables contribute most of the work in checkpoint time. Any better choices there? Thanks, Frank --047d7bdc878ac5827d04f599470e

Easiest: onstat -z shortly before a scheduled checkpoint then monitor onstat -g ppf to see IO activity by partnum immediately after thecheckpoint completes. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Mar 27, 2014 at 12:43 PM, FRANK <yunyaoqu@gmail.com> wrote: > Folks, > > IDs11.50 FC8 > > We have more work/job/volume which make checkpoint times very long ( > hundreds seconds) > > I want to monitor which tables contribute most of the work in checkpoint > time. > > Any better choices there? > > Thanks, > Frank > > --047d7bdc878ac5827d04f599470e > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c352a4b55bff04f59958d2