Checkpointing Databases

Use the checkpoint command to force SAP ASE to write modified data pages from memory to disk.

When you issue a checkpoint, SAP ASE freezes all current data-modifying transactions while writing to the disk. See the Reference Manual: Commands.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Temporary Databases
    • Proxy Databases
    • Archive Databases
    • In-Memory Databases
    • In-Memory Temporary Databases
  3. Click the Name field of the database, then click the drop-down arrow and select Checkpoint.
  4. Confirm that you want to run checkpoint on the current database.
Related tasks
Checking Database Consistency