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
-- --- ------------------ ---- --- ------------ ------------ --------------
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26224914/viewspace-2148162/