List DB2 History


=============================================================
List DB2 History
=============================================================

To display the events for the specific database use the “db2 list history” command

[db2inst1@mercury ~]$ db2 list history all for SAMPLE

ScreenShot : Lists the DB2 History Details for Sample Database
listhistory

Other Options …

[db2inst1@mercury ~]$db2 list history since 19980201 for sample
[db2inst1@mercury ~]$db2 list history backup containing userspace1 for sample
[db2inst1@mercury ~]$db2 list history dropped table all for db sample

 

Leave a Reply

Your email address will not be published. Required fields are marked *