DB2 V7, ZOS 1.4, Data order after recovery

William Proctor

DB2 V7, ZOS 1.4, Data order after recovery
Thanks for all replies in advance.

When you do a recovery on a tablespace does it put the rows
back exactly as they were when you took the image copy or does it put
them back according to the clustering index on the table? Or some other
method?







Bill Proctor

DB2 DBA

DB2 UDB V7.1 Database Administration for OS/390

TG

Austin, Texas

Phone: 512-219-4847





"It is even better to act quickly and err than to hesitate until the
time of action is past." -- Karl von Clausewitz.




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

Steen Rasmussen

Re: DB2 V7, ZOS 1.4, Data order after recovery
(in response to William Proctor)
Happy New Year Bill,



The recover utility will restore the tablespace page by page as the
pages were image copied, so this is not an alternate reorg method.

If the recover will do log-apply (in other words the recovery is not a
TOCOPY utility) the rows might not be in the same place as when the
image copy was taken (due to update activity etc. happening between the
image copy time and the TOLOGRBA.



Steen Rasmussen
CA
Senior Consultant DB2 tools

Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)

Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]
< http://www.ca.com >

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Proctor, William
Sent: Tuesday, January 02, 2007 2:48 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 V7, ZOS 1.4, Data order after recovery



Thanks for all replies in advance.

When you do a recovery on a tablespace does it put the rows
back exactly as they were when you took the image copy or does it put
them back according to the clustering index on the table? Or some other
method?







Bill Proctor

DB2 DBA

DB2 UDB V7.1 Database Administration for OS/390

TG

Austin, Texas

Phone: 512-219-4847





"It is even better to act quickly and err than to hesitate until the
time of action is past." -- Karl von Clausewitz.



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

James Campbell

Re: DB2 V7, ZOS 1.4, Data order after recovery
(in response to Steen Rasmussen)
Recover of an image copy will put pages, and the data on them, back
exactly as they were before. Levelset ids will be updated.

Recover using a log identifies data by pageset/page/row-id/offset - because
that is what is in the log. It does not know about clustered indexes - it does
not even know what the key of a row is. Consequently a recovery of an
insert will put the row into the same page that it was in before. "Exactly"?
There is a possibility that some rows might end up in a different physical
location on a page.

James Campbell

On 2 Jan 2007 at 14:47, Proctor, William wrote:

>
> Thanks for all replies in advance.
> When you do a recovery on a tablespace does it put the rows back exactly as they were
> when you took the image copy or does it put them back according to the clustering index on the
> table? Or some other method?
>
>
>
> Bill Proctor
> DB2 DBA
> DB2 UDB V7.1 Database Administration for OS/390
> TG
> Austin, Texas
> Phone: 512-219-4847
>
>
> "It is even better to act quickly and err than to hesitate until the time of action is past."-- Karl von
> Clausewitz.
>
>
> --------------------------------------------------------------------------------- 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 DB2-L-
> [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