COMMIT command

This dynamic command flushes to disk all pending buffered data. For performance reasons, the persistent data store does not immediately write to disk every update to a persistent table. Updates are buffered in virtual storage. Eventually the buffered updates are flushed (written to disk) at an optimal time. However, this architecture makes it possible for persistent data store files to become corrupted (not valid) if the files are closed prematurely, before pending buffered updates have been flushed. Such premature closings might leave inconsistent information in the files. The COMMIT command is intended to limit the exposure to data store file corruption. Some applications automatically issue this command after inserting data.

Important: The content in this section was created for and applies to the original persistent data store, referred to as PDS V1. A new PDS version (referred to as PDS V2) now exists. PDS V1 will eventually be deprecated.

The following known circumstances might cause corrupted files:

Severe abnormal monitoring server terminations that prevent the persistent data store recovery routines from executing
IPLs performed without first stopping the monitoring server

Syntax

COMMIT