Backup / Restore System on Db2 for z/OS

David Simpson

Backup / Restore System on Db2 for z/OS
Anybody using this? I have a client looking into it and we have some specific questions about SMS / ICF catalog configuration. We're also curious about how pervasive it is.

Thanks in advance!

Phil Grainger

Backup / Restore System on Db2 for z/OS
(in response to David Simpson)
I'm also interested

Most times I've asked, I get crickets!

Sent from my iPhone

On 29 Nov 2017, at 22:47, David Simpson <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Anybody using this? I have a client looking into it and we have some specific questions about SMS / ICF catalog configuration. We're also curious about how pervasive it is.

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.

Steen Rasmussen

Backup / Restore System on Db2 for z/OS
(in response to David Simpson)
Hey David, I mostly see this at SAP sites, but there's an increase of interest for non-SAP shops - but I agree with Grainger that it isn't used a lot (people stick to what's working). There's also a concern about additional DASD spending.

Steen rasmussen, CA

From: David Simpson [mailto:[login to unmask email]
Sent: Wednesday, November 29, 2017 5:47 PM
To: [login to unmask email]
Subject: [DB2-L] - Backup / Restore System on Db2 for z/OS

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Anybody using this? I have a client looking into it and we have some specific questions about SMS / ICF catalog configuration. We're also curious about how pervasive it is.

Thanks in advance!

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

David Simpson

RE: Backup / Restore System on Db2 for z/OS
(in response to David Simpson)

Thanks Phil & Steen,

This client has an SAP-like out-of-the-box application in a subsystem.  Not a ton of data but lots of tables that would never be recovered independently of each other. Disk is not an issue and Flash Copy is available.

Edited By:
David Simpson[Organization Members] @ Nov 29, 2017 - 10:36 PM (America/Eastern)

Steven Lamb

RE: Backup / Restore System on Db2 for z/OS
(in response to David Simpson)

We use BACKUP / RESTORE SYSTEM in all our DB2 systems, from test through to a prod online 24x7 banking system  - guess which non-IBM products we use. :).

 

If you've got any questions about the SMS / ICF user cat stuff, I'll have a go at answering or get my z/OS chums for help.

It works for us.

Regards,

Steve

Edited By:
Steven Lamb[Organization Members] @ Nov 30, 2017 - 08:45 AM (Europe/London)

Roy Boxwell

Backup / Restore System on Db2 for z/OS
(in response to David Simpson)
I go to a bunch of sites that use this on a regular basis. One is heavy SAP on z (quite rare these days!) one is a huge shop where they use this *and* normal image copies all together. They had some issues when the SLB copies were not actually flashed and none ever noticed that the copies failed as DFS only gave a rc=04 and nobody checks rc=04s do they? The weird thing was when they had to do a recovery the tablespace was RW until the RECOVER job failed! Then the RECOVER utility put the TS in COPY pending status... not that funny at the time but all fixed now...
Once you get the IBM recommended ICF set up (Three groups of HLQs basically) it works really well!


Roy Boxwell

SOFTWARE ENGINEERING GMBH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert

From: David Simpson [mailto:[login to unmask email]
Sent: Wednesday, November 29, 2017 11:47 PM
To: [login to unmask email]
Subject: [DB2-L] - Backup / Restore System on Db2 for z/OS

Anybody using this? I have a client looking into it and we have some specific questions about SMS / ICF catalog configuration. We're also curious about how pervasive it is.

Thanks in advance!

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

Steven Lamb

RE: Backup / Restore System on Db2 for z/OS
(in response to Roy Boxwell)

We rarely have issues with the BACKUP side of things, but we generally perform any RESTOREs using HSM to restore the DB2 Copypool from tape or FlashCopy disks, then use RESTORE SYSTEM LOGONLY.

There are limitations with just using DB2 RESTORE SYSTEM to do everything, so we use commands such as

HSEND WAIT FRRECOV CP(DSN£WV00£DB) ALLOWPPRCP(YES)

We're currently on DB2 11 - I haven't checked to see if there are any improvements in v12 yet.

Regards,

Steve

David Simpson

RE: Backup / Restore System on Db2 for z/OS
(in response to Roy Boxwell)

Thanks Roy,

What are the 3 HLQs?

1. BSDS and Log
2. Data
3. ??

This would be a change here as the BSDS, logs and all data use the SSID as the HLQ along with some other things.

Steven Lamb

RE: Backup / Restore System on Db2 for z/OS
(in response to David Simpson)

The trick is to have all datasets that you want to restore on disks (Storage Groups) defined in the SMS Copypools that get restored - £DB and £LG, with all the associated ICF cats also on these same volumes. Nothing else should be in these ICF cats.

1. Catalog and data pagesets are in one ICF Cat, using the same HLQ. RUNLIB.LOAD and SRCLIB.DATA use a different HLQ but are in the same ICF cat as the pagesets as they are restored

2. BSDS and Active logs - we use multi-part aliases, with the second qualifier denoting the subsystem, so each subsystem in a DSG has its own ICF cat for the Active logs, meaning a four-way DSG has four ICF cats for active logs, held in the £LG Copypool

3. We have the DB2 work tablespaces (DB07) set up with a different HLQ to the Catalog and data pagesets, as we don't restore these.

4. Other datasets - archive logs, DB2 runtime datasets etc. use various HLQs - these datasets are not in the £DB and £LG Copypools and are not restored.

 

Other people may have different flavours of this of course.

 

Regards,

Steve