Working on a small development database can make it difficult to identify certain problems that only become visible when you are dealing with a full size production database, a high level of concurrency, contention, and thousands of statements executed.
You will now validate the Profiler by starting the server in profiler mode: Complete these instructions if the Profiler is not correctly setup in your system.
To profile an application, you need to install the Remote Agent Controller on the machine where the JVM is running.
This, when combined with high level interfaces and reusable components, can create flexible and customizable frameworks.
A common problem with technologies like this (that abstract the data layer) is that you lose visibility into what is being done in the database.
Starting with version 7, Rational Application Developer now includes an integrated Remote Agent Controller for local profiling and installing the Agent Controller is no longer required.