开始学习DB2，记录一下自己的学习成果。

list history command的解释

>>-LIST HISTORY--+-------------------+-------------------------->
                 +-BACKUP------------+   
                 +-ROLLFORWARD-------+   
                 +-DROPPED TABLE-----+   
                 +-LOAD--------------+   
                 +-CREATE TABLESPACE-+   
                 +-ALTER TABLESPACE--+   
                 +-RENAME TABLESPACE-+   
                 +-REORG-------------+   
                 '-ARCHIVE LOG-------'   

>--+-ALL--------------------------------+----------------------->
   +-SINCE--timestamp-------------------+   
   '-CONTAINING--+-schema.object_name-+-'   
                 '-object_name--------'     

>--FOR--+----------+--database-alias---------------------------><
        +-DATABASE-+                   
        '-DB-------'                   

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