Db2 11 for z/OS - need steps for redirected restore of Base TS + LOB TS from prior imagecopyies ..

kapil mathur

Db2 11 for z/OS - need steps for redirected restore of Base TS + LOB TS from prior imagecopyies ..

Hi DB2-L members,

            I am in a DB2 11 for z/OS shop. There is a Production DB2 table that contains LOB columns (i.e. one base tablespace + multiple auxiliary  tablespaces, all of which are imagecopied (at SHRLEVEL REFERENCE via the same LISTDEF statement/same jobstep) every night. Hence the imagecopies of the base tablespace and aux. tablespaces are "in sync" with each other.

I would like to "restore" the data from all the related imagecopies (all imagecopies taken 2 days ago) into a copy of the same table in our Development DB2 environment. The layouts of the table/indexes in Production and Development environment are identical.
Is there any way to accomplish this "redirected restore" with the help of DB2 utilities and IBM DB2 High Performance Unload (as the DBAs in my shop do not have authority to use DSN1COPY) ... thanks in advance     

Phil Grainger

Db2 11 for z/OS - need steps for redirected restore of Base TS + LOB TS from prior imagecopyies ..
(in response to kapil mathur)
Without additional tools, dsn1copy is your ONLY option

Sorry

________________________________

Phil Grainger

Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






From: kapil mathur [mailto:[login to unmask email]
Sent: 15 May 2018 20:18
To: [login to unmask email]
Subject: [DB2-L] - Db2 11 for z/OS - need steps for redirected restore of Base TS + LOB TS from prior imagecopyies ..


Hi DB2-L members,

I am in a DB2 11 for z/OS shop. There is a Production DB2 table that contains LOB columns (i.e. one base tablespace + multiple auxiliary tablespaces, all of which are imagecopied (at SHRLEVEL REFERENCE via the same LISTDEF statement/same jobstep) every night. Hence the imagecopies of the base tablespace and aux. tablespaces are "in sync" with each other.

I would like to "restore" the data from all the related imagecopies (all imagecopies taken 2 days ago) into a copy of the same table in our Development DB2 environment. The layouts of the table/indexes in Production and Development environment are identical.
Is there any way to accomplish this "redirected restore" with the help of DB2 utilities and IBM DB2 High Performance Unload (as the DBAs in my shop do not have authority to use DSN1COPY) ... thanks in advance

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

  • image001.jpg (8k)
  • image002.png (5.9k)

Kai Stroh

RE: Db2 11 for z/OS - need steps for redirected restore of Base TS + LOB TS from prior imagecopyies ..
(in response to kapil mathur)

Phil is correct, without any additional tools you will have to use DSN1COPY. It is possible to run UNLOAD on image copies, but not for LOB or XML data. Operating system tools like IDCAMS REPRO cannot do the required OBID translation and reset the log RBAs and level IDs, so Db2 would not be able to read the resulting tablespaces correctly.

I work for a company that offers a tool that will do exactly what you are describing - it will generate DDL, copy tablespaces (including LOB and XML) and indexes directly from image copies into a different target, and also take care of things like copying RUNSTATS information, updating sequences, run all required utilities such as REBUILD INDEX or REPAIR CATALOG, and much more. Please contact me directly if you would like to get more information.