Blocking Checkpoint?

Ifmx 12.10.FC14 Solaris 10 1/13 What does it mean when a checkpoint shows "# Waits" = 1, but "Block Time", "Ckpt Time", "Wait Time", "Long Time" are all zero? 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 880488 13:44:00 CKPTINTVL 51521:0x1776018 0.5 0.5 0.0 1 0.0 0.0 0.0 19381 19381 13099 21 24250 40​​ Thank you. DG ------------------------------ David Grove ------------------------------ #Informix

This would mean that there was a single session that had to wait before entering a critical section for the checkpoint to happen. It waited less than 0.1 seconds, otherwise you would see the wait time be > 0. With such a short wait, it's unlikely to be a problem. ------------------------------ Mike Walker ------------------------------

It means that one session experienced a block that lasted less than 0.5sec during that checkpoint. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------