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
Ask a Question
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

troubleshooting Question

Tracking DB2 database transactions delays

Avatar of LeTay
LeTay asked on
DB2
9 Comments1 Solution564 ViewsLast Modified:
We have a large application that accesses a DB2 database
That application processes "batch" files that arrives in a special directory
Upon "receiving" of a file, the application (JBoss, Java) processes it by accessing the DB for many many queries, updates and inserts
Several files, and this is often the case, can be processes simultaneously.
However when this is the case, it seems that there are some long locking period  in the database as the completion of the work is longer and longer
We wonder if there is a DB2 tool (monitoring) that we can activate, and that will trace all requests sent to the RDBMS, but also indicating how long it took for each of these to complete
ASKER CERTIFIED SOLUTION
Avatar of gmarino
gmarino

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

Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers