Articles & Content


[F09] The ABC’s of Disaster Recovery

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2013

This is your first disaster recovery drill, and you are wondering what is involved. We will go thru the process from A to Z.

Our discussion will start with an overview of the fundamentals of DB2 infrastructure: the catalog and directory, the BSDS, and the active and archive logs.

After a review of the basics, we are ready for the disaster recovery drill. We will start with the preparation that is needed at the local site prior to the drill, followed by a deep dive into the jobs that will be run to recover the DB2 subsystem at the recovery site.

Along the way you will see how the Change Log Inventory program is used to update the BSDS with archive logs, generate the Conditional Restart Record, and add active logs. You will see the effects of these updates on the BSDS and some zparm options will also be covered. In addition, we will discuss some options that you have such as restoring archive copies to disk, or formatting the active logs.

We will then look at the job necessary to recover the catalog and directory, and we will see how this job changes based on the presence and type of user-defined catalog indexes.

Our discussion will also highlight the differences in the process in a non-datasharing system versus a datasharing system.

By the time we are finished, you will fully understand the steps necessary to recover your DB2 subsystem at the disaster recovery site. All that remains is for you to recover your application objects!

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.