Solved

Transaction Logs

Posted on 2011-02-15
7
583 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:philprescott
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 34897897
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
 

Author Comment

by:philprescott
ID: 34897999
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
 
LVL 37

Assisted Solution

by:momi_sabag
momi_sabag earned 500 total points
ID: 34898083
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
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 

Author Comment

by:philprescott
ID: 34904490
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
 
LVL 37

Assisted Solution

by:momi_sabag
momi_sabag earned 500 total points
ID: 34907119
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35196751
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question