Command Reference

LIST BACKUP/HISTORY

Lists restore sets for full database and table space level backups, or lists entries in the recovery history file.

Authorization

None

Required Connection

Instance. An explicit attachment is not required. If the database is listed as remote, an instance attachment to the remote node is established for the duration of the command.

Command Syntax

>>-LIST---+-BACKUP--+-+-ALL-------------------------------+-----> +-HISTORY-+ +-SINCE--timestamp------------------+ +-CONTAINING--+-schema.object_name-++ +-object_name--------+ >-FOR--+----------+-database-alias----------------------------->< +-DATABASE-+ +-DB-------+

Command Parameters

BACKUP

Lists backups and restores.

HISTORY

Lists backups, restores, and loads.

ALL

Lists all entries in the recovery history file.

SINCE timestamp

A complete time stamp (format yyyymmddhhnnss), or an initial prefix (minimum yyyy) can be specified. All entries with time stamps equal to or less than the time stamp provided are listed.

CONTAINING schema.object_name

This qualified name uniquely identifies a table.

CONTAINING object_name

This unqualified name uniquely identifies a table space.

FOR DATABASE database-alias

Used to identify the database whose recovery history file is to be listed.

Examples

db2 list backup containing t3.table50 for sample
 
db2 list history since 19970201 for sample

Usage Notes

The report generated by this command contains the following symbols:

• Device
  • A - ADSM
  • D - Disk
  • K - Diskette
  • O - Other
  • T - Tape
  • U - User Exit

• Object
  • D - Database
  • P - Tablespace
  • T - Table

• Operation
  • B - Backup
  • C - Copy
  • L - Load
  • R - Restore

• Type
  • F - Offline
  • I - Insert(LOAD)
  • N - Online

[ DB2 List of Books | Search the DB2 Books ]