troubleshooting Question

DB2 AIX 6.1 - how to reduce COMMIT time and increase TRANSACTION LOG?

Avatar of Haho
Haho asked on
DB2
4 Comments1 Solution1498 ViewsLast Modified:
hi guys,

(1) How do I reduce the intervals between COMMITs?
I want my database to COMMIT more often, therefore reducing the need to have a large transaction log because my database is very large... even clearing / deleting a few days data can cause the transaction log to fill up easily... as one day's data can have 50000 - 100000 records.

Also, (2) how do I increase the transaction log?

Please kindly advice. Esp if there are any other solutions... Thanks!
ASKER CERTIFIED SOLUTION
yongsing

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros