Archive log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre HIRTH - 27 Nov 2003 12:23 GMT

Hi,
Someone could tel me ho can i do to put a database in Archive log Mod ?
And how can i do to apply redo log on a backup database ?

Thank's

Reply to this Message

Blair Adamache - 27 Nov 2003 12:28 GMT

answers below

> Hi,
> Someone could tel me ho can i do to put a database in Archive log Mod ?

turn logretain on (db2 update db cfg using logretain on) and enable the
user exit

> And how can i do to apply redo log on a backup database ?

After the backup is restored, use the follforward command

> Thank's

For more details, read the Recovery sections of the amin guide.

Reply to this Message

Pierre Saint-Jacques - 27 Nov 2003 21:24 GMT

On a command line:
db2 update db cfg for <yourdbname> using logretain recovery
When successful it will put your db in backup pending state.
db2 backup db <yourdbname> to <yourtarget>

You are now ready to proceed. Your logs will be int the deafault log path
and you will have to mange their archiving.
Look in the on line DB2 Admin. Guide as to your options.
Whenever you need to restore, then look at the COmmand in the help function
db2 ? restore
db2 restore db <yourdbname> from <yourtarget> taken at
<datetimetampofbackup>
db2 rollforward db <yourdbname> to end of logs and stop

HTH, Pierre

> Hi,
> Someone could tel me ho can i do to put a database in Archive log Mod ?
> And how can i do to apply redo log on a backup database ?
>
> Thank's

Reply to this Message