Solved

Transaction Logs

Posted on 2011-02-15
7
582 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
  • 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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AS400 DB2 to MS SQL Server 2012 4 1,491
I am trying to get distinct column value and count in db2 8 101
Catalog Index 9 125
iSeries DB2 - Query with Sub Query? 7 113
November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

740 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