Articles & Content

Archives

Ding Dong the Quiesce is Dead! (G03)

Topic: DB2 for z/OS

Subtopic: 2007



DATE: 2007-11-5 (16:15 - 17:15)
SPEAKERS: Jim Dee (BMC Software )

Since we first started developing applications to run against DB2, the use of the Quiesce utility has been a painful necessity. We add Quiesce calls at any point in the application workflow to which we might want to recover, and then tolerate the outages. In many shops, taking a Quiesce is impossible, which leads to the really painful situation of enduring timeouts in SQL code for a Quiesce which ultimately fails. This presentation is about BMC's Timestamp recovery, which does not need a Quiesce or even a "quiet point" to support consistent data recovery.

EXP. LEVEL: Advanced

OBJECTIVES:

That use of the Quiesce utility to provide potential recovery points is no longer necessary

How to specify the syntax for a recovery to leave the data in a consistent state, even when the point of recovery is not consistent

How to explain the concept of identifying and undoing inflight transactions

How to explain the differences between forward and backout techniques of timestamp recovery

An understanding of the advantages and disadvantages of the forward and backout techniques



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.