db2 list history backup输出信息中各个类型的解释

  • Post author:
  • Post category:其他


查看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 



版权声明:本文为star62003原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。