Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


Share this Page URL
Help

Recovering a dropped database > Recovering a database using DB2 commands - Pg. 208

You can find the logs that are required for a given online backup by issuing the following command: db2 list history backup all for <database name> Example 7-8 shows the output of an online backup using this command. Example 7-8 List history output for an online backup Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID -- --- ------------------ ---- --- ------------ ------------ -------------- B D 20051018201659001 N D S0000193.LOG S0000195.LOG ---------------------------------------------------------------------------- Contains 2 tablespace(s): 00001 USERSPACE1 00002 SMSDAT1 ---------------------------------------------------------------------------- Comment: DB2 BACKUP VPS ONLINE Start Time: 20051018201659 End Time: 20051018201720 Status: A ---------------------------------------------------------------------------- EID: 11 Location: /db2backup