To QUIESCE or not QUIESCE, that is the question

Bill Brown

To QUIESCE or not QUIESCE, that is the question
Looking for opinions. I understand the purpose of the quiesce utility, but running it in a busy shop is very difficult. In most cases when we recover we recover to current. Since we don't do pit recoveries what is the real value of including a quiesce step after an image copy. The step ends up going down with the unable to drain message, gets a return code of 8, and then I get a phone call in the middle of the night. What is the rest of the worlds opinion on this????



[login to unmask email]

Re: To QUIESCE or not QUIESCE, that is the question
(in response to Bill Brown)
I would think the QUIESCE point that you are trying to take would be for
DR. If you don't use these in your DR recovery, for example you always
recover to a TOCOPY, then you would not need them. (my opinion)

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



"DB2 DBA"
<[login to unmask email] To: [login to unmask email]
SOUTH.NET> cc:
Sent by: "DB2 Subject: To QUIESCE or not QUIESCE, that is
Data Base the question
Discussion
List"
<[login to unmask email]
OM>


01/04/02
08:19 AM
Please
respond to
"DB2 Data
Base
Discussion
List"






Looking for opinions. I understand the purpose of the quiesce utility, but
running it in a busy shop is very difficult. In most cases when we recover
we recover to current. Since we don't do pit recoveries what is the real
value of including a quiesce step after an image copy. The step ends up
going down with the unable to drain message, gets a return code of 8, and
then I get a phone call in the middle of the night. What is the rest of
the worlds opinion on this????








Michael Ebert

Re: To QUIESCE or not QUIESCE, that is the question
(in response to John_Lendman@FPL.COM)
There have been heated discussions in the past, check the archives...
My opinion: as you said, a QUIESCE point is useful for PIT recovery. E.g.
sometimes our developers want to have some tables cleaned out, do some
tests, then want the data restored. Here I do an IC+QUIESCE first and
later a RECOVER TORBA. Generally I'd use a QUIESCE only ahead of some
(error-prone) batch that might gobble up data, and only if there is online
activity as well.
Doing a QUIESCE routinely before or after an IC is pointless.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




Looking for opinions. I understand the purpose of the quiesce utility,
but running it in a busy shop is very difficult. In most cases when we
recover we recover to current. Since we don't do pit recoveries what is
the real value of including a quiesce step after an image copy. The step
ends up going down with the unable to drain message, gets a return code of
8, and then I get a phone call in the middle of the night. What is the
rest of the worlds opinion on this????

Bill Gallagher

Re: To QUIESCE or not QUIESCE, that is the question
(in response to Michael Ebert)
The best use of the QUIESCE utility is to provide a common point of
consistency for multiple tablespaces/indexspaces, so that you can perform a
PIT restore and ensure data integrity and consistency across all objects.
For instance, you would want to QUIESCE all tablespaces that are
referentially related (whether using DB2 RI or application-enforced RI) to
establish a point of PIT recoverability.

If you don't need to do PIT recoverability for a particular database, then
the QUIESCE doesn't really do much for you.

Our local and DR recover strategies rely heavily on PIT recoveries, so we
use the QUIESCE utility extensively.

-------------------------------------------------------------------------------------------------------


Bill Gallagher, DBA
Phoenix Life Insurance
Enfield, CT 06083

IBM Certified Solutions Expert - DB2 UDB v7.1 Database Administration for
OS/390
IBM Certified Solutions Expert - DB2 UDB v7.1 Database Administration for
UNIX, Windows, and OS/2




"DB2 DBA"
<[login to unmask email] To: [login to unmask email]
SOUTH.NET> cc:
Sent by: "DB2 Subject: To QUIESCE or not QUIESCE, that is the question
Data Base
Discussion
List"
<[login to unmask email]
OM>


01/04/02
08:19 AM
Please
respond to
"DB2 Data
Base
Discussion
List"






Looking for opinions. I understand the purpose of the quiesce utility, but
running it in a busy shop is very difficult. In most cases when we recover
we recover to current. Since we don't do pit recoveries what is the real
value of including a quiesce step after an image copy. The step ends up
going down with the unable to drain message, gets a return code of 8, and
then I get a phone call in the middle of the night. What is the rest of
the worlds opinion on this????








Troy Coleman

Re: To QUIESCE or not QUIESCE, that is the question
(in response to Bill Gallagher)
I use this for point in time recovery. One way to make this run faster is
to use the WRITE NO option. You will not wait to flush the buffers. I
found this to help. I've setup QUIESCE in several PeopleSoft installations
with many databases, tablespaces and indexes all being QUIESCE at the same
time.
Good Luck,

Troy Coleman
Coleman Consulting, Inc.

IBM Certified Solutions Expert - DB2 V7.1 Database Administrator for OS/390
IBM Certified Advanced Technical Expert DB2 - DRDA
IBM Certified Solutions Expert - DB2 UDB V5 Database Administrator

907 W. Dorset Ave.
Palatine, IL 60067
(847) 722-2698
mailto: [login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
DB2 DBA
Sent: Friday, January 04, 2002 7:19 AM
To: [login to unmask email]
Subject: To QUIESCE or not QUIESCE, that is the question


Looking for opinions. I understand the purpose of the quiesce utility, but
running it in a busy shop is very difficult. In most cases when we recover
we recover to current. Since we don't do pit recoveries what is the real
value of including a quiesce step after an image copy. The step ends up
going down with the unable to drain message, gets a return code of 8, and
then I get a phone call in the middle of the night. What is the rest of the
worlds opinion on this????