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!
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504