Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is QUIESCE?

asked mar August 20, 2014 12:10 PM  

What is QUIESCE?


2 Answers

answered By Mswami   0  

  • Sets a ‘bookmark’ in the DB2 log,indicating the RBA at which NO activity is occurring on the specified table space(s)
  • Use this utility to produce an RBA that can later be used for a point-intime (PIT) recovery of the table space(s)
  • Several spaces can be quiesced in a single request
  • Runs very quickly
  • Use this in production wherever you want to establish a possible recovery point.
   add comment

answered By Mswami   0  

The QUIESCE utility establishes a quiesce point for a table space, partition, table space set, or list of table spaces and table space sets. A quiesce point is a point at which data is consistent across these objects. You can later recover a table space to its quiesce point by using the RECOVER utility.

When you request that the QUIESCE utility take a quiesce point, the quiesce point is the current log RBA or log record sequence number (LRSN). QUIESCE then records the quiesce point in the SYSIBM.SYSCOPY catalog table.

A quiesce point is not essential when you plan for point-in-time recoveries. The RECOVER utility can recover data to a prior point-in-time with consistency without a quiesce point. The utility can recover objects with transactional consistency, which means that the objects contain only data that has been committed. However, recovering objects to a quiesce point can be faster because no work must be backed out. You might also want to establish quiesce points for related sets of objects if you need to plan for a point-in-time recovery for the entire set.
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 1 year and 1 month ago ago
Number of Views -164
Number of Answers -2
Last updated
2 years and 2 months ago ago

  Similar questions

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!