IBM Support

In DB2 V9.5 for LUW an Online Backup to TSM creates two entries in the history file.

Troubleshooting


Problem

When you run an online backup to TSM, we record the backup twice in the history file. This does not happen if the online backup is run to disk, or if an offline backup is run to TSM.

Symptom


db2 backup db sample online use TSM ==> Puts 2 entries in the history file
db2 backup db sample use TSM ==> Puts only one entry in the history file
db2 backup db sample online ==> This is to disk, it still puts only 1 entry in the history file.

db2adutl query shows only 1 image for the online backup on TSM.

db2 list history backup all for db sample

 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20080316164650001   N    A  S0000000.LOG S0000000.LOG
 ----------------------------------------------------------------------------
  Contains 2 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP SAMPLE ONLINE
 Start Time: 20080316164650
   End Time: 20080316164706
     Status: A
 ----------------------------------------------------------------------------
  EID: 3 Location: adsm/libtsm.a


 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20080316164650002   N    A  S0000000.LOG S0000000.LOG
 ----------------------------------------------------------------------------
  Contains 2 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP SAMPLE ONLINE
 Start Time: 20080316164650
   End Time: 20080316164706
     Status: A
 ----------------------------------------------------------------------------
  EID: 4 Location: adsm/libtsm.a

Environment

Db2 LUW - Tivoli Storage Manager

Resolving The Problem


In DB2 V9.5, the INCLUDE LOGS option has become the default for an online backup and for an offline single system view (SSV) backup of a multi-partitioned database. When we backup to TSM, we generate 2 sequence files, one to contain the backup image, the other to contain the log files. This is the reason we put 2 entries in the history file for an online backup to TSM.

This is working as per design.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Recovery - Backup","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.5","Edition":"Enterprise Server;Express;Personal;Personal Developer's;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21303220

Page Feedback