troubleshooting Question

How can I induce a DB2 commit while executing a thrd-party application that does not commit frequently or not at all and often filling my log and filesystem?

Avatar of Enachioken
EnachiokenFlag for United States of America asked on
DB2LinuxUnix OSOperating Systems
6 Comments3 Solutions275 ViewsLast Modified:
Hi all,

I have a situation where a third-party application accessing a DB2 database periodically fills up the log files
which eventually leads to filesystem full problems. Since we don't have anyway of modifying third-party vendor
code to add commits or such things, I am wondering if they is any way possible to make DB2 take a commit
outside of the application accessing the DB2 database? When this happens, the server/database is rebooted and the application
restarted. I will like to eliminate this problem.

What I am trying to say is this: Can DB2 Checkpointing for example be used in anyway to "induce" a kind of
commit for the system and application without having to reboot every time I have a system full stoppage?

Any and all suggestions is appreciated.

B2 9.1
DB2 10.1

LSB Version:    :core-3.0-ia32:core-3.0-noarch:graphics-3.0-ia32:graphics-3.0-noarch
Distributor ID: RedHatEnterpriseES
Description:    Red Hat Enterprise Linux ES release 4 (Nahant Update 9)
Release:        4
Codename:       NahantUpdate9

Kent Olsen
Data Warehouse / Database Architect

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

Join our community to see this answer!
Unlock 3 Answers and 6 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 3 Answers and 6 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