Articles & Content

Archives

Ding Dong the Quiesce is Dead! (I14)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-05-22 (10:30 AM - 11:30 AM)
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



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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