FS
Documentation

Backup3G/DA-DB2 1.2 Release Notes

This page was last modified 01:54, 25 February 2008.

From Documentation

< Backup3G(Difference between revisions)
Jump to: navigation, search
Revision as of 01:49, 25 February 2008
Moff (Talk | contribs)
(Recoverying DB2 Databases)
← Previous diff
Current revision
Moff (Talk | contribs)
(Database backup cannot span more than one tape)
Line 102: Line 102:
==== Database backup cannot span more than one tape ==== ==== Database backup cannot span more than one tape ====
-When performing an Online Database or+When performing an Online Database or Offline Database backup an error will occur when end of media is reached. It is recommended that Database backups be the first step in a backup job. Otherwise use the Tablespace backup methods.
-Offline Database backup an error will occur when end of media is reached. It is recommended that+
-Database backups be the first step in a backup job. Otherwise use the Tablespace backup methods.+
<br> <br>
 +
== Hardware and OS Dependencies == == Hardware and OS Dependencies ==
None known. None known.

Current revision

Contents

Overview and Features

This is the second release of the DB2 backup module. This module has also been certified for use with DB2 7.1, 7.2 and DB2 8.1.

The distribution is generic and will run on all UNIX platforms supported by COSbackup 3.2.5 or greater.


Features in DA-DB2


Environment

Software Prerequisites

Before you can install DA-DB2 1.2, COSmanager 4.2.1 (or newer) and COSbackup 3.2.6 (or newer) must already be installed on the same host.


Disk Space Required

DA-DB2 1.2 is installed under the COSbackup home directory. It requires less than 200 Kbytes disk space.


Supported DB2 Versions

DA-DB2 1.2 supports DB2 7.1, 7.2 and 8.1.


Notes

Simultaneous Backups

You cannot run two or more backup jobs of the same database at the same time. The exception is an Online Tablespace backup. To decrease the backup window, multiple backup jobs of the same database may be run at the same time. Each job specifies which tablespaces are included or excluded—example: -t <tablespaces> or -x <tablespaces>

To avoid backing up the active logs in each job that is being run at the same time, specify that active logs are to be ignored in all but one of the jobs—example: -A


Backing Up from Instances of DB2

To perform any DB2 backup of an instance on a host, specify the name of the associated DB2 user for that instance in the Options field when you add or change a Backup Item—example: -u <username>

Instance details are configured by COSbackup configuration > Initial configuration > Configure Data Avalability for DB2


Backing Up Archived Logs

If archived logs are copied elsewhere by a “User Exit”script, specify the archived logs directory in the Options field when you add or change a Backup Item—example: -a <archived logs dir>


Protect File Patterns

The DB2 offline and Oracle online backup methods can accept a file pattern comprising a list of files to be backed up along with the DB2 object. The file pattern is specified in the Options field when you add or change a Backup Item.

This pattern is globbed before being passed to the method. Protect file patterns with quotes (example: -s “*/*savefile”) to make sure they are passed correctly to the backup method.


Database has Status “Backup Pending”

A db2 database backup needs to be performed either from the command line or from db2cc or from COSbackup before the database will return to a Consistent state.


Recoverying DB2 Databases

The suggested process is as follows:

1. Deactivate the datebase being restored
code su - <db2 user>
db2 deactivate database <db>
If you get messages about being unable to deactivate, then there are client connections that need to be killed, then deactivate again
2. Perform the restore, whether it be from an offline, online or archived logs backup via COSbackup > Recover
3. Roll the database forward
code db2 rollforward database <db> to end of logs and complete
Should show that the roll forward is successful and what the first active log is
4. Activate the database
code db2 activate database <db>
5. Check the database is consistent
code db2 connect to <db>
db2 get database config
Check the output (near the beginning) such that:
Backup pending = NO
Database is consistent = YES
Rollforward pending = NO
Restore pending = NO
5. Log out
code db2 connect reset
exit


Warnings

Archive Log Backups with no Archive Logs

When performing an archived log backup, and no archived logs are found, the backup job will succeed even though no files are backup up.


Database backup cannot span more than one tape

When performing an Online Database or Offline Database backup an error will occur when end of media is reached. It is recommended that Database backups be the first step in a backup job. Otherwise use the Tablespace backup methods.


Hardware and OS Dependencies

None known.



August 2004
Copyright © 1990-2024 Functional Software. All rights reserved.