Link to home
Create AccountLog in
Avatar of philprescott
philprescott

asked on

Transaction Logs

Hi,

I have got an error 'SQL0964C The transaction log for database is full. SQLSTATE=57011' on my DB2 v9.7 HP-UX.

Now, in order to resolve this issue I increased my primary and secondary log files to 50 each. Also, I set my
ARCHMETHOD1 to DISK:<Path> where <Path> is equal to 20GB in size.

Now, can you tell me if take my online backup after every week and then after 3rd week, can I delete the 1st week archived log files along with the history and backup in order to claim the space back.

Kindly do remember that we could only take an offline backup after 3-4 months as this is not possible for us.

Regards.
ASKER CERTIFIED SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of philprescott
philprescott

ASKER

Is it a full offline or online backup that you are talking about.

We do not want to keep the log files for first week after third week.

How does in the real world people take the backup of their database and get rid of the old log files without making the database offline.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks for the solution.

Can I fully recover from the full online backup that I had taken previously without losing any data to that point.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Guy Hengel [angelIII / a3]
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.