Any update on this ?

-----Original Message-----
From: "Iswariya Vasan " <db2udbdba-ezmlmshield-x9191736.[Email address protected]
Sent: Friday, August 26, 2005 9:55 AM
To: "LazyDBA Discussion" <[Email address protected]
Subject: Back Up and Logging




Hi All,

I've few doubts over this back up recovery and logging types. Can anybody clarify me on this?

1) I've set my production database logging type as "Archival". And for archiving logs I've set the Manual archival process. This means that periodically I've to go to that log file folder take the old logs and put it in another folder? Is this what it means?

2) Can anybody send me links for examples on writing User Exit routine, which will automate the process of archiving old log files.

3) In both the cases(manual archival or user exit routine), the old log files will be moved to another location. So when I do a restore of the latest back up of the production database and rollforward to the end of logs, should I also specify the archived log files location since only from the archival log file folder the log files starts . Iam a bit confused in how DB2 will work on rolling forward transaction upto the end of logs in cases where I've moved my log files.

4) Also, say for todays transaction there are 5 log files generated. I restore yesterdays backup version and now I want to rollforward to 1,2,3 and 5th log file alone. In this case, While rolling forward to the end of logs, will it not throw an error saying that "Logs Missing" ? How can I do this ?

5) Roll forward to a specific time. Should I enter the Log file saved time which appears when I put a ls l command in the unix shell prompt ? How should I give the time in 'local" or "GMT" the options specified in the wizard.?

Please clarify my doubts regarding the 4 points mentioned above.

Regards
Iswariya Vasan




PLEASE CLICK REPLY ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page