Archive log

[Pierre HIRTH]

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

[Blair Adamache]

Re: Archive log

answers below

Pierre HIRTH wrote:
[color=blue]
> Hi,
> Someone could tel me ho can i do to put a database in Archive log Mod ?[/color]

turn logretain on (db2 update db cfg using logretain on) and enable the
user exit
[color=blue]
> And how can i do to apply redo log on a backup database ?[/color]

After the backup is restored, use the follforward command
[color=blue]
>
> Thank's[/color]

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

[Pierre Saint-Jacques]

Re: Archive log

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
<datetimetampof backup>
db2 rollforward db <yourdbname> to end of logs and stop

HTH, Pierre
"Pierre HIRTH" <lepierot@yahoo .fr> a écrit dans le message de
news:aef82276.0 311270423.72b9b 01b@posting.goo gle.com...[color=blue]
> 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[/color]