Command Reference

LIST HISTORY

Lists entries in the history file. The history file contains a record of recovery and administrative events. Recovery events include full database and table space level backup, restore, and roll forward. Additional logged events include alter table space, run statistics, reorganize table, drop table, and load.

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 HISTORY----+-------------------+------------------------>
                   +-BACKUP------------+
                   +-ROLLFORWARD-------+
                   +-ALTER TABLESPACE--+
                   +-DROPPED TABLE-----+
                   +-LOAD--------------+
                   '-RENAME TABLESPACE-'
 
>-----+-ALL--------------------------------+-------------------->
      +-SINCE--timestamp-------------------+
      '-CONTAINING--+-schema.object_name-+-'
                    '-object_name--------'
 
>----FOR--+----------+---database-alias------------------------><
          +-DATABASE-+
          '-DB-------'
 

Command Parameters

HISTORY

Lists all recovery and administration events which are currently logged in the history file.

BACKUP

Lists backup and restore operations.

ROLLFORWARD

Lists roll forward operations.

ALTER TABLESPACE

Lists ALTER TABLESPACE operations.

DROPPED TABLE

Lists dropped tables.

LOAD

Lists load operations.

RENAME TABLESPACE

Lists RENAME TABLESPACE operations.

ALL

Lists all entries of the specified type in the 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 history since 19980201 for sample
   db2 list history backup containing userspace1 for sample
   db2 list history dropped table all for db sample

Usage Notes

The report generated by this command contains the following symbols:

• Device
  • A - TSM
  • C - Client
  • D - Disk
  • K - Diskette
  • L - Local
  • O - Other
  • P - Pipe
  • S - Server
  • T - Tape
  • U - User Exit
• Object
  • D - Database
  • P - Tablespace
  • T - Table
• Operation
  • B - Backup
  • C - Copy
  • D - Dropped table
  • F - Roll forward
  • G - Reorganize table
  • L - Load
  • N - Rename Tablespace
  • Q - Quiesce
  • R - Restore
  • S - Run statistics
  • T - Alter table space
  • U - (for future use)
• Type
  • C - Alter Tablespace (add containers)
  • E - End of log
  • F - Offline
  • I - Insert(LOAD)
  • N - Online
  • P - Point in time
  • R - Alter Tablespace (rebalance)
  • S - Quiesce Share
  • U - Quiesce Update
  • X - Quiesce Exclusive
  • Z - Quiesce Reset
• Entry Status
  • D - Deleted (for future use)
  • E - Expired
  • I - Inactive
  • N - Not yet committed
  • Y - Committed or active