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.
philprescottAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
momi_sabagConnect With a Mentor Commented:
the question if you should keep your logs after a backup or not is a matter of requirements

if you take a full backup once a week (and you use the parameter include logs), you can delete the logs that are older than the backup,
but then you will not be able to restore to a previous point in time before that backup. You will only be able to restore to the point in time of the backup or after it (Assuming the backup is not corrupted).
0
 
philprescottAuthor Commented:
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.
0
 
momi_sabagConnect With a Mentor Commented:
you can take full online backups and use the include logs parameter
after such a backup you can delete all the older log files
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
philprescottAuthor Commented:
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.
0
 
momi_sabagConnect With a Mentor Commented:
as long as you use the include logs parameter
you should give it a try in your testing system to make sure that you get it right before deleting production log files
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.