db2 list history backup輸出資訊中各個型別的解釋

flywiththewind發表於2016-08-24
轉自:http://blog.csdn.net/star62003/article/details/8724198
檢視DB2歷史備份資訊的兩個例子:

db2 list history backup all for dbname
db2 list history backup since 20130301 for dbname


輸出的列表中關於backup記錄資訊中關於型別的詳細解釋如下:(摘自DB2 InfoCenter)


Usage notes

The report generated by this command contains the following symbols:

Operation A - Create table space B - Backup C - Load copy
   D - Dropped table
   F - Roll forward
   G - Reorganize table
   L - Load
   N - Rename table space
   O - Drop table space
   Q - Quiesce
   R - Restore
   T - Alter table space
   U - Unload
   X - Archive log Type Archive Log types:
   P - Primary log path
   M - Secondary (mirror) log path
   F - Failover archive path
   1 - Primary log archive method
   2 - Secondary log archive method  Backup types: F - Offline
   N - Online
   I - Incremental offline
   O - Incremental online
   D - Delta offline
   E - Delta online

Rollforward types:

   E - End of logs
   P - Point in time

Load types:

   I - Insert
   R - Replace

Alter table space types:

   C - Add containers
   R - Rebalance

Quiesce types:

   S - Quiesce share
   U - Quiesce update
   X - Quiesce exclusive
   Z - Quiesce reset 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26224914/viewspace-2123903/,如需轉載,請註明出處,否則將追究法律責任。

相關文章