View Single Post
  #3 (permalink)  
Old 03-08-03, 17:15
caroor caroor is offline
Registered User
 
Join Date: Mar 2003
Posts: 3
Re: DB2 UDB 7 Backup

Thanks, that helped.

Quote:
Originally posted by sathyaram_s
You can have either an online or offline backup ....

Well, for offline backup, obviously, no users should be connected to the database ... If you know that no one is supposed to be connected do 'force application' ...

For online backup, you need to have logretain or userexit enabled ...

db2 update db cfg for <dbname> using logretain on

This will switch the database from circular to linear logging ...

For more details go to www.ibm.com/db2/library and look out for a manual on backup/recovery(I don't remember it's name)

HTH

Cheers

Sathyaram
Reply With Quote