Need a tool to enhance and check the performance of DB2 Native SQL Stored Procedure

We run the Stored procedures via UI applications where we cannot let it run for more than 2 sec (at max 2 secs) otherwise the UI application will face time out error. we code the Stored procedures in Mainframes and the execute them thru SQLDBX.

Please help as performance improvement has become one of the most important factor here.

We run the Stored procedures via UI applications where we cannot let it run for more than 2 sec (at max 2 secs) otherwise the UI application will face time out error. we code the Stored procedures in Mainframes and the execute them thru SQLDBX.

Please help as performance improvement has become one of the most important factor here.

I'm not familiar with SQLDBX. On the mainframe, the Resource Limit Facility (RLF) can be used, either predictively or reactively, to limit the CPU used. It's available in all supported releases of DB2 for z/OS.

Do you agree? Disagree? And remember, it's all about the reputation power...