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
Quote:
Originally posted by caroor
I am trying set up a scheduled online back of a database, but have not been successful. I either get a "The database is currently in use" or "Online backup is not allowed because either logretain or userexit for roll-forward is not activated, or a backup pending condition is in effect for the database" error.
All I need to accomplish is to get a scheduled backup once a day. Transactions/database changes in between are not important.
How can I accomplish this? I have searched IBM's web site and googled, but have got no where. I am about to tear my hair out. Can someone pleas help?
Thanks
Chandru
|