Antwort: [DB2-L] Full imagecopy with shrlevel change

Roy Boxwell

Antwort: [DB2-L] Full imagecopy with shrlevel change
I would sincerely hope that it would not be measurable!

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de





"Smith, Allan" <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
28.11.2006 15:46
Bitte antworten an DB2 Database Discussion list at IDUG


An: [login to unmask email]
Kopie:
Thema: [DB2-L] Full imagecopy with shrlevel change


Can anyone tell me what impact on the system (response times/CPU times)
would occur if we run a full image copy with shrlevel change on some very
large tables? The tables in question are both 4k pages and 32k pages.
Thanks


---------------------------------------------------------------------------------
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

George Burnette

Re: Full imagecopy with shrlevel change
(in response to Roy Boxwell)
Related to below: If a full image copy is created with shrlevel change
(no existing backups), is there a way to recover from the copy and apply
log records to bring the table to current state with no quiesce having
been performed ?

Thanks,
George

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Smith, Allan
Sent: Tuesday, November 28, 2006 9:46 AM
To: [login to unmask email]
Subject: [DB2-L] Full imagecopy with shrlevel change



Can anyone tell me what impact on the system (response times/CPU
times) would occur if we run a full image copy with shrlevel change on
some very large tables? The tables in question are both 4k pages and
32k pages.

Thanks




------------------------------------------------------------------------
--------- 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

Michael Ebert

Re: Full imagecopy with shrlevel change
(in response to Andy Lankester)
a) the performance impact is negligible
b) yes, that's the normal M/O. You need a QUIESCE only if you want to do a
Point-in-time (PiT-) recovery.

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




"Burnette, George" <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
Re: [DB2-L] Full imagecopy with shrlevel change





"Burnette, George" <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
28-11-06 16:52


Related to below: If a full image copy is created with shrlevel change
(no existing backups), is there a way to recover from the copy and apply
log records to bring the table to current state with no quiesce having
been performed ?

Thanks,
George
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Smith, Allan
Sent: Tuesday, November 28, 2006 9:46 AM
To: [login to unmask email]
Subject: [DB2-L] Full imagecopy with shrlevel change

Can anyone tell me what impact on the system (response times/CPU times)
would occur if we run a full image copy with shrlevel change on some very
large tables? The tables in question are both 4k pages and 32k pages.
Thanks

---------------------------------------------------------------------------------
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

Mike Bell

Re: Full imagecopy with shrlevel change
(in response to Michael Ebert)
Bringing the table to current is the default and does not require a QUIESCE.
QUIESCE is required to recover a set of tables to a consistent logrba. This
will let you recover multiple tables with related data (DB2 RI or not) to a
state where there are no partial updates. The normal use of this is either
at a DR site where you don't want partial data or to recover to a point
before current because something happened (bad software update, errors in
application code, etc).

Mike
HLS Technologies



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Burnette, George
Sent: Tuesday, November 28, 2006 9:52 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Full imagecopy with shrlevel change

Related to below: If a full image copy is created with shrlevel change (no
existing backups), is there a way to recover from the copy and apply log
records to bring the table to current state with no quiesce having been
performed ?

Thanks,
George

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Smith, Allan
Sent: Tuesday, November 28, 2006 9:46 AM
To: [login to unmask email]
Subject: [DB2-L] Full imagecopy with shrlevel change



Can anyone tell me what impact on the system (response times/CPU
times) would occur if we run a full image copy with shrlevel change on some
very large tables? The tables in question are both 4k pages and 32k pages.

Thanks




----------------------------------------------------------------------------
----- 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


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003

---------------------------------------------------------------------------------
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

Andy Lankester

Re: Full imagecopy with shrlevel change
(in response to George Burnette)
Just do an IBM recover to current (the default). You only need a QUIESCE if you need to do a PiT recovery.

Andy Lankester

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Burnette, George
Sent: Tuesday, November 28, 2006 3:52 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Full imagecopy with shrlevel change


Related to below: If a full image copy is created with shrlevel change (no existing backups), is there a way to recover from the copy and apply log records to bring the table to current state with no quiesce having been performed ?

Thanks,
George

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Smith, Allan
Sent: Tuesday, November 28, 2006 9:46 AM
To: [login to unmask email]
Subject: [DB2-L] Full imagecopy with shrlevel change



Can anyone tell me what impact on the system (response times/CPU times) would occur if we run a full image copy with shrlevel change on some very large tables? The tables in question are both 4k pages and 32k pages.

Thanks



--------------------------------------------------------------------------------- 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


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.19/555 - Release Date: 27/11/2006



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.19/555 - Release Date: 27/11/2006


---------------------------------------------------------------------------------
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

Nick Cianci

Re: Full imagecopy with shrlevel change
(in response to Mike Bell)
Allan,
generally there shouldn't be a significant impact with the
SHRLEVEL(CHANGE).

However:

1.
If you are copying these tables with a LISTDEF using a high
degree of parallelism against highly active tables, you could suffer
some IOSQ degradation, unless you have PAV enabled DASD. Note
parallelism is controllable \ tunable, so monitor and ramp up or down as
required.
2.
You will still have the same serialisation consideration when
you Quiesce a RI-set of tables

HTH

Regards,

Nick CIANCI
EDS Australia ADU | Acting Team Leader DBA - DB2|
Level 2 Allara House, 48-52 Allara St, Canberra, ACT 2601 |
Office: +61-2-6275-5863 | Mobile: 0417-28 92 56 |
Fax: +61-2-6275-6064 | Email: [login to unmask email]
<mailto:[login to unmask email]> |

IBM Certified Solutions Expert
- DB2 UDB V7.1 Database Administration for OS/390

This correspondence is for the named person's use only. It may
contain confidential or legally privileged information or both. No
confidentiality or privilege is waived or lost by this transmission. If
you receive this correspondence in error, please immediately delete it
from your system and notify the sender. You must not disclose, copy or
rely on any part of this correspondence if you are not the intended
recipient.


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Smith, Allan
Sent: Wednesday, 29 November 2006 1:46 AM
To: [login to unmask email]
Subject: [DB2-L] Full imagecopy with shrlevel change



Can anyone tell me what impact on the system (response times/CPU
times) would occur if we run a full image copy with shrlevel change on
some very large tables? The tables in question are both 4k pages and
32k pages.

Thanks




------------------------------------------------------------------------
--------- 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

Craig McKellar

Re: Full imagecopy with shrlevel change
(in response to Nick Cianci)
Using a Log tool will either find you a quiet period (ie consistent
points across selected group of tables) and/or record a quiesce point
from which you can do a consistent PIT recovery.
You can also use one of the tools IBM Change Accum Tool(with latest
maint) or BMC recover + (and most likely a CA eqiv.) to build a set of
sharelevel reference image copies from the sharelevel change to a
nominated quiesce point.

regards
Craig

Burnette, George wrote:

> Related to below: If a full image copy is created with shrlevel
> change (no existing backups), is there a way to recover from the copy
> and apply log records to bring the table to current state with no
> quiesce having been performed ?
>
> Thanks,
> George
>
> -----Original Message-----
> *From:* DB2 Data Base Discussion List [mailto:[login to unmask email]
> *On Behalf Of *Smith, Allan
> *Sent:* Tuesday, November 28, 2006 9:46 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] Full imagecopy with shrlevel change
>
> Can anyone tell me what impact on the system (response times/CPU
> times) would occur if we run a full image copy with shrlevel
> change on some very large tables? The tables in question are both
> 4k pages and 32k pages.
>
> Thanks
>
>
>
> ---------------------------------------------------------------------------------
> 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



---------------------------------------------------------------------------------
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