Couple of things :
a] If you switch the database to archivelog mode from circular logging - your database will be place in backup pending. You can ascertain this by the following command :
db2 get db cfg for <dbname> | grep -i backup
Backup pending = NO/YES
At this point you will have to take an offline backup of the database and if you are using EEE, it means doing the catalog node first.
After you are done, you can activate the database.
There is a registry variable called DB2_DISABLE_FLUSH_LOG. Depending on your requirements, you can set this value to OFF or ON.
You can see it's current value using the command :
db2set -all
When an online backup is run, UDB truncates the currently active log on each node. You can disable this feature by setting DB2_DISABLE_FLUSH_LOG =ON and it will not truncate the log before the backup starts - however the log/s will have to be available during recovery.
Thanks,
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
|