Avatar of Enachioken
Enachioken
Flag for United States of America asked on

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?

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


Thanks
DB2LinuxUnix OSOperating Systems

Avatar of undefined
Last Comment
Kent Olsen

8/22/2022 - Mon
SOLUTION
arnold

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Kent Olsen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Enachioken

ASKER
Thanks kdo. I don't have all the answers to your questions. I will try to find out the answers between now and Monday.

Again, thanks
Enachioken,
SOLUTION
Gary Patterson, CISSP

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Enachioken

ASKER
Decided to let the question lapse.  we had to cancel the product deployment and the vendor.
Kent Olsen

Sorry that you had to cancel the deployment.

I suspect that some simple tuning of DB2 could have made things a lot better.


Ketn
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy