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