SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure

The SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure checkpoints the database by flushing all cached data to disk.

Syntax

SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()

No result is returned by this procedure.

Execute privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this procedure by default. See "Configuring user authentication" and "Configuring user authorization" in the Derby Security Guide for more information. The database owner can grant access to other users.

JDBC example

CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()");
cs.execute();
cs.close();

SQL Example

CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();