We help IT Professionals succeed at work.
Get Started

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?

Last Modified: 2016-03-12
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

Watch Question
Data Warehouse / Database Architect
This problem has been solved!
Unlock 3 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE