Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying IBM DB2 9.7 Advanced Administration Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

4.5 (8)
close
close
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

4.5 (8)

Overview of this book

IBM DB2 LUW is a leading relational database system developed by IBM. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems in the market. IBM DB2 9.7 Advanced Administration Cookbook covers all the latest features with instance creation, setup, and administration of multi-partitioned database. This practical cookbook provides step-by-step instructions to build and configure powerful databases, with scalability, safety and reliability features, using industry standard best practices. This book will walk you through all the important aspects of administration. You will learn to set up production capable environments with multi-partitioned databases and make the best use of hardware resources for maximum performance. With this guide you can master the different ways to implement strong databases with a High Availability architecture.
Table of Contents (21 chapters)
close
close
IBM DB2 9.7 Advanced Administration Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Recovery history file


This file is created at database creation time. It is updated automatically when backup or restore operations occur on the database, or on a table space. Table space operations, such as, creation, quiesce, rename, or drop, among others, also will have an impact on this file.

In our recipe, we will deliberately corrupt a history file and recover using an existing backup.

Getting ready

Please use a sandbox environment to duplicate this experience. Allow for the downtime to restart the instance.

We will corrupt the recovery history file by copying something else into this file. We already made a backup, so we're fine. Perhaps you would like to make a precautionary copy of this file first.

How to do it...

  1. Make a precautionary copy of the recovery history file:

    [db2inst1@nodedb21 ~]$ pwd
    /home/db2inst1
    [db2inst1@nodedb21 ~]$ cd /data/db2/db2inst1/NODE0000/SQL00001
    [db2inst1@nodedb21 SQL00001]$ ls -l db2rhist.asc
    -rw-r----- 1 db2inst1 dba 15362 2011-08-05 20:08 db2rhist.asc
    [db2inst1...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY