DB2 z/OS Recover TOLOGPOINT with a different Target?

John SooHoo

DB2 z/OS Recover TOLOGPOINT with a different Target?

Hello Listers,

Tools such as FDR, DFDSS, etc. have typically provided a way to restore datasets to a different target (DSNAME).

Is it possible to do something like this with Recover Tologpoint?  (Tologpoint is specified to remove uncommitted data as the image copy is SHRLEVEL CHANGE.)  In other words, we would like to place the results of the Recover in an identical table with a different name, so as to not disrupt the availability and usage of the original table.

Having looked at the Recover portion of the Utility Guide, it does not appear possible with a straight Recover Tologpoint as I don't see such an option described.  Perhaps a combination of steps or tools?

Thanks in advance for any ideas.

John SooHoo

Venkat Srinivasan

RE: DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to John SooHoo)

There is no native support.  Log analysis tools can be used to generate undo redo sqls. If copying objects enmasse there are tools for cloning.  

Venkat
 
In Reply to John SooHoo:

Hello Listers,

Tools such as FDR, DFDSS, etc. have typically provided a way to restore datasets to a different target (DSNAME).

Is it possible to do something like this with Recover Tologpoint?  (Tologpoint is specified to remove uncommitted data as the image copy is SHRLEVEL CHANGE.)  In other words, we would like to place the results of the Recover in an identical table with a different name, so as to not disrupt the availability and usage of the original table.

Having looked at the Recover portion of the Utility Guide, it does not appear possible with a straight Recover Tologpoint as I don't see such an option described.  Perhaps a combination of steps or tools?

Thanks in advance for any ideas.

John SooHoo

Daniel Luksetich

DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to Venkat Srinivasan)
If you do a DSN1COPY with id translation from the SHRLEVEL CHANGE image copy dataset you may have to remove duplicate rows, but otherwise I think you would be OK.
Cheers,
Dan

From: Venkat Srinivasan [mailto:[login to unmask email]
Sent: Wednesday, December 28, 2016 11:45 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS Recover TOLOGPOINT with a different Target?

There is no native support. Log analysis tools can be used to generate undo redo sqls. If copying objects enmasse there are tools for cloning.
Venkat

In Reply to John SooHoo:
Hello Listers,
Tools such as FDR, DFDSS, etc. have typically provided a way to restore datasets to a different target (DSNAME).
Is it possible to do something like this with Recover Tologpoint? (Tologpoint is specified to remove uncommitted data as the image copy is SHRLEVEL CHANGE.) In other words, we would like to place the results of the Recover in an identical table with a different name, so as to not disrupt the availability and usage of the original table.
Having looked at the Recover portion of the Utility Guide, it does not appear possible with a straight Recover Tologpoint as I don't see such an option described. Perhaps a combination of steps or tools?
Thanks in advance for any ideas.
John SooHoo

-----End Original Message-----

Phil Grainger

DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to Venkat Srinivasan)
Or certain ISV recovery tools can do EXACTLY what is needed here


BMC would be a good place to start looking, but I suspect the OP will require a solution that either he already owns or one that does not require additional purchase. Which is a pity


Phil G

BMC Software

________________________________
From: Venkat Srinivasan <[login to unmask email]>
Sent: 28 December 2016 17:44
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS Recover TOLOGPOINT with a different Target?


There is no native support. Log analysis tools can be used to generate undo redo sqls. If copying objects enmasse there are tools for cloning.

Venkat

In Reply to John SooHoo:

Hello Listers,

Tools such as FDR, DFDSS, etc. have typically provided a way to restore datasets to a different target (DSNAME).

Is it possible to do something like this with Recover Tologpoint? (Tologpoint is specified to remove uncommitted data as the image copy is SHRLEVEL CHANGE.) In other words, we would like to place the results of the Recover in an identical table with a different name, so as to not disrupt the availability and usage of the original table.

Having looked at the Recover portion of the Utility Guide, it does not appear possible with a straight Recover Tologpoint as I don't see such an option described. Perhaps a combination of steps or tools?

Thanks in advance for any ideas.

John SooHoo

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.

Venkat Srinivasan

RE: DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to Daniel Luksetich)

He wants a time consistent copy to be applied. That requires log apply. You can't apply log that belongs to a pageset to a different pageset unless aided by a separate process outside of DB2 framework that does such a change by translating the internal identifiers during log apply. (as described by Phil )

Venkat

In Reply to Daniel Luksetich:

If you do a DSN1COPY with id translation from the SHRLEVEL CHANGE image copy dataset you may have to remove duplicate rows, but otherwise I think you would be OK.
Cheers,
Dan

From: Venkat Srinivasan [mailto:[login to unmask email]
Sent: Wednesday, December 28, 2016 11:45 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS Recover TOLOGPOINT with a different Target?

There is no native support. Log analysis tools can be used to generate undo redo sqls. If copying objects enmasse there are tools for cloning.
Venkat

In Reply to John SooHoo:
Hello Listers,
Tools such as FDR, DFDSS, etc. have typically provided a way to restore datasets to a different target (DSNAME).
Is it possible to do something like this with Recover Tologpoint? (Tologpoint is specified to remove uncommitted data as the image copy is SHRLEVEL CHANGE.) In other words, we would like to place the results of the Recover in an identical table with a different name, so as to not disrupt the availability and usage of the original table.
Having looked at the Recover portion of the Utility Guide, it does not appear possible with a straight Recover Tologpoint as I don't see such an option described. Perhaps a combination of steps or tools?
Thanks in advance for any ideas.
John SooHoo

-----End Original Message-----

John SooHoo

RE: DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to Daniel Luksetich)

I seem to recall that an inline image copy of an online reorg might have the same page copied more than once and so could have duplicates but that should not occur in a stand-alone image copy correct?  Or am I missing something else here?

John

Daniel Luksetich

DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to John SooHoo)


A shrlevel change image copy can have duplicates as an updated row may
change locations while the copy is executing.

Cheers,

Dan

On 12.28.2016 13:34, John SooHoo wrote:

> I seem to recall that an inline image copy of an online reorg might have the same page copied more than once and so could have duplicates but that should not occur in a stand-alone image copy correct? Or am I missing something else here?
>
> John
>
> -----End Original Message-----


Links:
------
[1] http://www.idug.org/p/fo/st/post=179506&amp;anc=p179506#p179506
[2] http://www.idug.org/p/fo/si/topic=19
[3] http://www.idug.org/p/us/to/
[4] http://www.idug.org/na
[5] http://www.idug.org/p/cm/ld/fid=2

Steen Rasmussen

DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to Phil Grainger)
Since my good old friend Phil Grainger started - not only BMC is capable of restoring an image copy into a different tablespace and optionally applying log-records to a PiT.
You are welcome to contact me offline.

Happy New Year

Steen Rasmussen
[login to unmask email]<mailto:[login to unmask email]>


From: Grainger, Phil [mailto:[login to unmask email]
Sent: Wednesday, December 28, 2016 12:37 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS Recover TOLOGPOINT with a different Target?


Or certain ISV recovery tools can do EXACTLY what is needed here



BMC would be a good place to start looking, but I suspect the OP will require a solution that either he already owns or one that does not require additional purchase. Which is a pity



Phil G

BMC Software

________________________________
From: Venkat Srinivasan <[login to unmask email]<mailto:[login to unmask email]>>
Sent: 28 December 2016 17:44
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 z/OS Recover TOLOGPOINT with a different Target?


There is no native support. Log analysis tools can be used to generate undo redo sqls. If copying objects enmasse there are tools for cloning.

Venkat

In Reply to John SooHoo:

Hello Listers,

Tools such as FDR, DFDSS, etc. have typically provided a way to restore datasets to a different target (DSNAME).

Is it possible to do something like this with Recover Tologpoint? (Tologpoint is specified to remove uncommitted data as the image copy is SHRLEVEL CHANGE.) In other words, we would like to place the results of the Recover in an identical table with a different name, so as to not disrupt the availability and usage of the original table.

Having looked at the Recover portion of the Utility Guide, it does not appear possible with a straight Recover Tologpoint as I don't see such an option described. Perhaps a combination of steps or tools?

Thanks in advance for any ideas.

John SooHoo

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
-----End Original Message-----

John SooHoo

RE: DB2 z/OS Recover TOLOGPOINT with a different Target?
(in response to Daniel Luksetich)

Ah, that makes sense.

I see this is more complex than I thought.

Thank you, Dan.

John



In Reply to Daniel Luksetich:



A shrlevel change image copy can have duplicates as an updated row may
change locations while the copy is executing.

Cheers,

Dan

On 12.28.2016 13:34, John SooHoo wrote:

> I seem to recall that an inline image copy of an online reorg might have the same page copied more than once and so could have duplicates but that should not occur in a stand-alone image copy correct? Or am I missing something else here?
>
> John
>
> -----End Original Message-----


Links:
------
[1] http://www.idug.org/p/fo/st/post=179506&anc=p179506#p179506
[2] http://www.idug.org/p/fo/si/topic=19
[3] http://www.idug.org/p/us/to/
[4] http://www.idug.org/na
[5] http://www.idug.org/p/cm/ld/fid=2