WRITE NO won't resolve the drain issue. Might make the utility run
which could perhaps reduce the potential for conflicts.
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
Administration for UNIX, Windows, and OS/2
IBM Certified Solutions Expert - DB2 UDB V7.1 Family Application
IBM Certified Advanced Technical Expert - DB2 Data Replication
Vice President of Global Database Operations
Database Performance Professionals
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jose de
Sent: Thursday, February 03, 2011 12:07 PM
To: [login to unmask email]
Subject: [SPAM] Quiesce Write Yes or No?
after every COPY with SHRLEVEL CHANGE, we execute a QUIESCE WRITE
Ocasionally we have an abend because the process couldn't drain an
As we don't have indexes with COPY YES, is it safe to change to
I think the answer is NO, but want to be sure.
I've seen a presentation where it says it's less disruptive. But
nothing about if it's safe to do it that way, at least in this
Have a good time,
> Introducing IBMR DB2R
10 for z/OS
The IDUG DB2-L Listserv is only part of your membership in IDUG. If
not already an IDUG member, please < http://www.idug.org/register
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:
* IDUG North America * Anaheim, California * May 2-6 2011 *
* Your only source for independent, unbiased, and trusted DB2
How can you expand your staff or do succession planning in this
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