this is probably the simple question bout I have doubts.
I have DB2 9.7 on Linux and it is with default circular logging.
Now I want to change it to archive logging to be able to do online backup.
I do this because I must set DB for backups with Tivoli Storage Manager.
What do I have to do?
I did this:
1.db2cc Configure Database Logging Wizard
2.choose archive logging
3.to choose "Use a user exit to archive the log files" or "Use DB2 to automatically log files" what is the difference? If second is chosen I choose for Media Type TSM and for failure path /opt/archive2
4.Set primary log number to 10 and secondary to 15. Size of each 4096
5.Logging location /opt/archive
6. Run now without saving task history
Does someone know is this enough to enable my database to be able for TSM?
Did I did something wrong?What do I have to do more?
What do I have to choose in 3-rd step?
I found some documentation but it doesnt giving me the exact steps for configuring.
Do I have to do some kind of scheduling on db level for performing database backup or on the side of TSM?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-10-11T18:56:39Z by SystemAdmin
Pinned topic How to set DB2 ready for Online backup? (from circullar to archive logging)
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-11T18:56:39Z at 2012-10-11T18:56:39Z by SystemAdmin
SystemAdmin 110000D4XK17917 PostsACCEPTED ANSWER
Re: How to set DB2 ready for Online backup? (from circullar to archive logging)2012-10-11T18:56:39Z in response to VeljkoCYou don't need to use archive logging (making the database rollforward recoverable) in order to perform DB2 backups to TSM. Regardless of the target of your backup images, they can always be either offline if that's what you require.
Having said that, you probably want to read a bit of info about logging and its implications. I'll suggest starting with one of these pages:
A 'user exit' for archive logging is not what I'd recommend, as it allows you to write your own log archive handling program. What you want is to either retain the logs in the active path (but beware that the disk there could fill up over time), or more commonly have DB2 automatically archive them to TSM or some other storage.
I'm not sure what you've already read, but there are whole sections of the books that discuss the use of TSM with DB2.
Hope that helps.