Personal tools
You are here: Home DB2 How To's Checking Useful Backup Information
Navigation
Log in


Forgot your password?
 
Document Actions

Checking Useful Backup Information

How to proceed if you need to check some information about your backup, such as what kind of backup it is (online, offline, incremental, full or delta) and what was the logs used during the backup image process

If you need information about backup images, such as type and range of logs used, perform the following command:


db2 list history backup all for <db_name>

It will show you all information about the backup images created recently.


Example:

db2 list history backup all for DBASE1

                    List History File for DBASE1

Number of matching file entries = 3


 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20080331213002001   N    D  S0030133.LOG S0030134.LOG
 ----------------------------------------------------------------------------
  Contains 9 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
  00003 TS_RECORD
  00004 TS_ENVIRONMENT
  00005 TS_SLOTS
  00006 TS_DATA
  00007 TS_INDEXES
  00008 TS_LONG
  00009 SYSTOOLSPACE
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP DBASE1 ONLINE
 Start Time: 20080331213002
   End Time: 20080331215718
     Status: E
 ----------------------------------------------------------------------------
  EID: 31967 Location: /backup/dbase1_bkp


 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20080331213002002   N    D  S0030133.LOG S0030134.LOG
 ----------------------------------------------------------------------------
  Contains 9 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
  00003 TS_RECORD
  00004 TS_ENVIRONMENT
  00005 TS_SLOTS
  00006 TS_DATA
  00007 TS_INDEXES
  00008 TS_LONG
  00009 SYSTOOLSPACE
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP DBASE1 ONLINE
 Start Time: 20080331213002
   End Time: 20080331215718
     Status: E
 ----------------------------------------------------------------------------
  EID: 31968 Location: /backup/dbase1_bkp


 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20080331213002003   N    D  S0030133.LOG S0030134.LOG
 ----------------------------------------------------------------------------
  Contains 9 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
  00003 TS_RECORD
  00004 TS_ENVIRONMENT
  00005 TS_SLOTS
  00006 TS_DATA
  00007 TS_INDEXES
  00008 TS_LONG
  00009 SYSTOOLSPACE
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP DBASE1 ONLINE
 Start Time: 20080331213002
   End Time: 20080331215718
     Status: E
 ----------------------------------------------------------------------------
  EID: 31969 Location: /backup/dbase1_bkp


As you can see, it is possible with the command to check several information about the created backup images, such as which tablespaces was made backup, what was the range of log files used, the directory where the image was created, the backup type and the start / end time of the backup process.


Some of the important information in the history file is:

Op
    This is the operation that was performed. In the exampled above it is a "B" which stands for backup. A list of the possible values for Op can be found in the Command Reference under the LIST HISTORY command.

Obj
    This is the granularity of the backup. "D" for database backup . "T" for tablespace backup.

Earliest Log
    In the case of an online backup, this is the first log required for the rollforward operation.

Current Log
    The last log that was written to when the backup completed. In the case of an online backup, this is the minimum log required for the backup to complete.

Type
    For backup operations, type "F" means full offline backup, "N" means full online backup, "I" means incremental offline backup, "O" means incremental online backup, "D" means delta offline backup and "E" means delta online backup.


The status of a backup operation: A - active, I - inactive, E - expired, or D - deleted


Security for databases
Which solution database auditing and protection do you use?









Polls