db2 list history 參考

flywiththewind發表於2017-12-01
DB2

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部落格 ” ，連結：http://blog.itpub.net/26224914/viewspace-2148162/，如需轉載，請註明出處，否則將追究法律責任。

相關文章