DB2 backup online summary

08 June,2011 by Jack Vamvas

How can I complete a DB2 backup online ?

Example of DB2 backup online

db2 backup database online use TSM

Read the DB2 documentation for a full list of parameters

DB2 backup online only works if : a) logretain is enabled or b)userexit is enabled.

If not,  you could see an error message DB2 SQL2413N - Online backup is not allowed 

While online database BACKUP is occurring , activities executed against the database are logged. An important aspect of defining a Backup Strategy – as existing transactions running beyond the BACKUP are not included .

When issuing a RESTORE DATABASE , RESTORE roll forward the logs at least up to the point where the BACKUP completed.

When the online backup finishes DB2 closes the current active log – which is archived.  If a RESTORE must occur – the online backup has a complete log set available.

The loghead database configuration displays the value of the lowest numbered active log .

A log with a sequence number smaller than the loghead are defined as archived logs .

These logs can be moved.

The loghead database configuration value displays the lowest numbered active log. Log sequence number lower than loghead are archived. Those files can now be managed. If TSM is configured – it will move these logs to the destination tape or drive.This depends on the  TSM backup client configuration for DB2 on Linux

Issuing the command  GET DB CONFIGURATION FOR MYDB   displays the First Active Log File value

Fist active log file 

Commands compatible with Online Backup

EXPORT

ONLINE INSPECT

ONLINE INDEX REORG

REBALANCE

IMPORT

ALLOW READ ACCESS LOAD

ONLINE TABLE REORG

DDLs (needing a Z lock)

RUNSTATS

Read More

Backup Retention Policy

DB2 – How to manage backup failures

DB2 – Backup history

The Backup failed







Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 backup online summary

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright