DB2 backup online summary

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

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