[DB2-L] QUIESCE 600 Tablespaces

Georg Peter

[DB2-L] QUIESCE 600 Tablespaces
Daniel,

one simple idea is to break your 600 tablespaces into "logical groups". E.g.
TS001 to TS100 one group, TS101 to TS200 second group,.....

Quiesce each group with a single QUIESCE statement.

The good thing is that these QUIESECE's can be run in parallel to decrease
the overall elapsed time...

HTH.

With kind regards - mit freundlichen Gruessen,
Georg H. Peter c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowledge Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------
"A journey of a thousand miles must begin with a single step...."


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag
von Daniel Cremieux
Gesendet: Dienstag, 18. Januar 2005 15:28
An: [login to unmask email]
Betreff: [DB2-L] QUIESCE 600 Tablespaces


Dear all,

We do a Quiesce of about 600 tablespaces every morning .
Currently , there is one statement/ tablespace .
I want to change it to

QUIESCE ts1 ts2 ts3 .. ts600


Is there any consideration before doing the change in term of MVS
ressource , longer elapsed time ? ...

Thank you

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bart Mertens

Re: QUIESCE 600 Tablespaces
(in response to Georg Peter)
Daniel,

In our shop we quiesce 750 tablespace every evening with a single listdef.
This takes about 8 seconds to complete.

Listdef sample statement:
LISTDEF FDRDUMP INCLUDE TABLESPACE ZLCZ*.* PARTLEVEL
INCLUDE TABLESPACE ZLLI*.* PARTLEVEL
INCLUDE TABLESPACE ZLZE*.* PARTLEVEL
INCLUDE TABLESPACE ZLPE*.* PARTLEVEL
INCLUDE TABLESPACE ZLEH*.* PARTLEVEL
INCLUDE TABLESPACE DB*LCZ.* PARTLEVEL
QUIESCE LIST FDRDUMP

met vriendelijke groeten,
Bart Mertens
Database Administrator DB2
CZ Actief in Gezondheid - Tilburg
* (013) 593 8256
* [login to unmask email]





==================
De informatie verzonden met dit e-mail bericht is vertrouwelijk en
uitsluitend bestemd voor de geadresseerde. Indien bovenstaand e-mailbericht
niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het
e-mailbericht te retourneren aan de verzender en het origineel en eventuele
kopieen te verwijderen en te vernietigen. Gebruik van deze informatie door
anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging,
verspreiding en/of verstrekking van deze informatie aan derden is niet
toegestaan. CZ staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden e-mail, noch voor tijdige ontvangst daarvan.

==================
The information contained in this communication is confidential and may be
legally privileged. If you are not the intended recipient of this
communication please return the communication to the sender and delete and
destroy all copies. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. CZ health
insurance is neither liable for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.

===================

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: QUIESCE 600 Tablespaces
(in response to Bart Mertens)
A single QUIESCE causes an entry to be made in SYSCOPY indicating the
named objects can be recovered consitantly to the associated LRSN
QUIESCE TS1;
QUIESCE TS2;
Provides a marker where either TS1 and TS2 can be recovered to a point
of consistancy but these points are not the same for both table spaces.
QUIESCE TS1, TS2;
Provides a marker where either TS1 and TS2 can be recovered to a point
of consistancy and these points are the same for both table spaces.

The case of Quiesce TS1, TS2 ... TS600 is much more difficult to achive
than QUIESCE TS1 unless the system is naturally idle.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Daniel Cremieux
Sent: Tuesday, January 18, 2005 9:28 AM
To: [login to unmask email]
Subject: [DB2-L] QUIESCE 600 Tablespaces

Dear all,

We do a Quiesce of about 600 tablespaces every morning .
Currently , there is one statement/ tablespace .
I want to change it to

QUIESCE ts1 ts2 ts3 .. ts600


Is there any consideration before doing the change in term of MVS
ressource , longer elapsed time ? ...

Thank you

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Georg Peter

AW: [DB2-L] QUIESCE 600 Tablespaces
(in response to Avram Friedman)
Antonis,

for the LISTDEF control statement I have found a useful link:

http://www.craigsmullins.com/dbu_0402.htm

With kind regards - mit freundlichen Gruessen,
Georg
----------------------------------------------------------------------
"A journey of a thousand miles must begin with a single step...."


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag
von Galeos Antonis
Gesendet: Dienstag, 18. Januar 2005 15:38
An: [login to unmask email]
Betreff: Re: [DB2-L] QUIESCE 600 Tablespaces


Hello Daniel

If you are in V7.1 DB2 you can use list



-----Original Message-----
From: Daniel Cremieux [mailto:[login to unmask email]
Sent: Tuesday, January 18, 2005 4:28 PM
To: [login to unmask email]
Subject: [DB2-L] QUIESCE 600 Tablespaces

Dear all,

We do a Quiesce of about 600 tablespaces every morning .
Currently , there is one statement/ tablespace .
I want to change it to

QUIESCE ts1 ts2 ts3 .. ts600


Is there any consideration before doing the change in term of MVS
ressource , longer elapsed time ? ...

Thank you

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


Disclaimer
This e-mail is confidential. If you are not the intended recipient, you
should not copy it, re-transmit it, use it or disclose its contents, but
should return it to the sender immediately and delete the copy from your
system.
EFG Eurobank Ergasias S.A. is not responsible for, nor endorses, any
opinion, recommendation, conclusion, solicitation, offer or agreement or any
information contained in this communication.
EFG Eurobank Ergasias S.A. cannot accept any responsibility for the accuracy
or completeness of this message as it has been transmitted over a public
network. If you suspect that the message may have been intercepted or
amended, please call the sender.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Hello

Re: QUIESCE 600 Tablespaces
(in response to Georg Peter)
thank you , we generate the tablespace list dynamically , in the past we
use listdef but our naming convention implies the risk of forgetting new
comers tablespaces

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm