ITPub博客

首页 > 数据库 > 数据库开发技术 > db2 list history 参考

db2 list history 参考

原创 数据库开发技术 作者:flywiththewind 时间:2017-12-01 15:50:47 0 删除 编辑

EXAMPLES:

 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20171130230002001   N    D  S0034060.LOG S0034062.LOG  
 ----------------------------------------------------------------------------
  Contains 10 tablespace(s):


 00001 SYSCATSPACE
 00002 SYSTOOLSPACE
 00003 EASTS8K
 00004 EASTS16K
 00005 EASTS32K
 00006 EASTSBLOB
 00007 EASTS16K_HRP2
 00008 EASTS32K_HRP2
 00009 EASTS8K_HRP2
 00010 EASTSBLOB_HRP2
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP DBNAME ONLINE
 Start Time: 20171130230002
   End Time: 20171201002929
     Status: A
 ----------------------------------------------------------------------------
  EID: 38047 Location: /db2data/db2backup1/DBNAME


 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20171129230034001   O    D  S0033992.LOG S0033993.LOG  
 ----------------------------------------------------------------------------
  Contains 10 tablespace(s):


 00001 SYSCATSPACE
 00002 SYSTOOLSPACE
 00003 EASTS8K
 00004 EASTS16K
 00005 EASTS32K
 00006 EASTSBLOB
 00007 EASTS16K_HRP2
 00008 EASTS32K_HRP2
 00009 EASTS8K_HRP2
 00010 EASTSBLOB_HRP2
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP DBNAME ONLINE
 Start Time: 20171129230034
   End Time: 20171129235655
     Status: A
 ----------------------------------------------------------------------------
  EID: 37977 Location: /db2data/db2backup1/DBNAME


Usage notes

The SYSIBMADM.DB_HISTORY administrative view can be used to retrieve data from alldatabase partitions.

In a DB2 pureScale instance, all DB history records for the database are global. The DB history records can be retrieved using the list history or administrative view interface connected to any member.

The report generated by this command contains the following symbols:
Operation

   A - Create table space
   B - Backup C - Load copy
   D - Drop table
   F - Rollforward
   G - Reorganize
   L - Load
   N - Rename table space
   O - Drop table space
   Q - Quiesce
   R - Restore
   T - Alter table space
   U - Unload
   X - Archive log

Object

   D - Database
   I - Index
   P - Table space
   T - Table
   R - Partitioned table

Type

   Alter table space operation types:

      C - Add container
      R - Rebalance

   Archive log operation types:
      F - Failover archive path
      M - Secondary (mirror) log path
      N - Archive log command
      P - Primary log path
      1 - Primary log archive method
      2 - Secondary log archive method Backup and restore operation types:

      D - Delta offline
      E - Delta online
      F - Offline
      I - Incremental offline M - Merged N - Online
      O - Incremental online
      R - Rebuild
   
   Load operation types:

      I - Insert
      R - Replace

   Rollforward operation types:

      E - End of logs
      P - Point-in-time

   Quiesce operation types:

      S - Quiesce share
      U - Quiesce update
      X - Quiesce exclusive
      Z - Quiesce reset History entry status flag:

   A - Active
   D - Deleted
   E - Expired
   I - Inactive
   N - Not yet committed P - Pending delete X - Do not delete
   a - Incomplete active
   i - Incomplete inactive

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26224914/viewspace-2148162/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: DB2 HADR相关参数1
下一篇: db2 hadr 限制
请登录后发表评论 登录
全部评论

注册时间:2011-08-30

  • 博文量
    146
  • 访问量
    207819