1 – Wait
Wait[/Until] Nowait Specifies whether or not the system prompt is to be returned before the checkpoint operation completes. When you specify the Wait qualifier without the Until qualifier, the system prompt is not returned to you until all processes have flushed updated database pages to disk. The Wait qualifier is the default. Used with the Wait qualifier, the Until qualifier specifies the time at which the RMU Checkpoint/Wait command stops waiting for the checkpoint and returns an error message. If you do not specify the Until qualifier, the wait is indefinite. When you specify the Nowait qualifier, the system prompt is returned immediately, before all processes have flushed database pages to disk. In addition, when you specify the Nowait qualifier, there is no guarantee that all processes will flush their database pages to disk. The Nowait qualifier is useful when it is more essential that the system prompt be returned immediately than it is to be certain that all processes have checkpointed.