Quiesce Write Yes or No?

Jose de Bedos

Quiesce Write Yes or No?


Hi List,

after every COPY with SHRLEVEL CHANGE, we execute a QUIESCE WRITE YES.
Ocasionally we have an abend because the process couldn't drain an index.
As we don't have indexes with COPY YES, is it safe to change to WRITE NO?
I think the answer is NO, but want to be sure.
I've seen a presentation where it says it's less disruptive. But says nothing about if it's safe to do it that way, at least in this case.

Have a good time,
Jose




_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Daniel Luksetich

Re: Quiesce Write Yes or No?
(in response to Jose de Bedos)
WRITE NO won't resolve the drain issue. Might make the utility run faster
which could perhaps reduce the potential for conflicts.

Dan



Daniel L Luksetich

IBM Information Champion

IBM Certified Database Administrator - DB2 10 for z/OS

IBM Certified System Administrator - DB2 9 for z/OS

IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database
Administration for UNIX, Windows, and OS/2

IBM Certified Solutions Expert - DB2 UDB V7.1 Family Application Development

IBM Certified Advanced Technical Expert - DB2 Data Replication



Vice President of Global Database Operations

YL&A, Inc.

Database Performance Professionals

http://www.ylassoc.com

http://www.db2expert.com

http://www-01.ibm.com/software/data/champion/profiles/luksetich.html







From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jose de Bedos
Sent: Thursday, February 03, 2011 12:07 PM
To: [login to unmask email]
Subject: [SPAM] Quiesce Write Yes or No?




Hi List,

after every COPY with SHRLEVEL CHANGE, we execute a QUIESCE WRITE YES.
Ocasionally we have an abend because the process couldn't drain an index.
As we don't have indexes with COPY YES, is it safe to change to WRITE NO?
I think the answer is NO, but want to be sure.
I've seen a presentation where it says it's less disruptive. But says
nothing about if it's safe to do it that way, at least in this case.

Have a good time,
Jose





_____

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ > Introducing IBMR DB2R
10 for z/OS

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please < http://www.idug.org/register > register
here.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.872 / Virus Database: 271.1.1/3420 - Release Date: 02/03/11
01:34:00


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv