Hi

有一天手动备份数据库，想看下数据库备份时间，于是找到了db2 list history backup all for 数据库命令。

DB2 backup

直接DB2CMD执行：

1 2	db2 connect to 数据库 user pas using pas db2 list history backup all for 数据库

结果：

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20220802175839001   F    D  S0000000.LOG S0000000.LOG
 ----------------------------------------------------------------------------
  Contains 9 tablespace(s):

 00001 SYSCATSPACE
 00002 TBS_MXZ
 00003 SYSTOOLSPACE
 00004 TBS_PAS
 00005 TBS_JKSJ
 00006 TBS_JXDX
 00007 TBS_NBZZ
 00008 TBS_IDX
 00009 TBS_LSB
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP YKSPAS3 OFFLINE
 Start Time: 20220802175839
   End Time: 20220802231447
     Status: A
 ----------------------------------------------------------------------------
  EID: 48531 Location: /home/db2inst1/SNPAS/PAS_BACKUP/PAS_BACKUP20220731

Start Time: 开始时间
End Time: 结束时间

拓展

查看数据库备份是否可用：

1	db2ckbkp -h /home/db2inst1/SNPAS/PAS_BACKUP/PAS_BACKUP20220731

一个爱老婆的Python程序猿。。。。。。

DB2数据库备份记录查询