Multiple choice technology web technology

which one is responsible for flushing all DB2 buffers on the disk?

  1. QUIESCE

  2. FREEPAGE

  3. PCTFREE

  4. TABLESPACE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

QUIESCE is a DB2 utility that forces all pending changes from the buffer pool to be written to disk, ensuring data consistency. It's particularly important before operations like backups, COPY, or LOAD to guarantee that all data is safely stored on disk. QUIESCE essentially does a checkpoint - it flushes all modified pages from memory to disk and records a point of consistency. FREEPAGE and PCTFREE are storage parameters controlling how much free space is reserved in table spaces for future inserts/updates. TABLESPACE is a container for tables, not a command or utility.

Keep practicing — related questions