how to monitorizing querys in database,

georgipa · #1 (**permalink**) 02-03-12, 18:43

Hi Colleagues,
Somebody can say me how to monitor the querys that are executing in database and view what are consuming more resource.

Thank you for advanced.

n_i · #2 (**permalink**) 02-03-12, 20:54

MON_CURRENT_SQL - Retrieve key metrics for all activities on all members - IBM DB2 9.7 for Linux, UNIX, and Windows
LONG_RUNNING_SQL - IBM DB2 9.7 for Linux, UNIX, and Windows
SNAPDYN_SQL and SNAP_GET_DYN_SQL_V95 - IBM DB2 9.7 for Linux, UNIX, and Windows
SNAPSTMT and SNAP_GET_STMT - IBM DB2 9.7 for Linux, UNIX, and Windows
db2top - DB2 monitoring tool command - IBM DB2 9.7 for Linux, UNIX, and Windows

georgipa · #3 (**permalink**) 02-04-12, 03:17

Hi colleagues,
I need capture the querys that are executing in database and cost for this querys and access plan for this querys, ¿somebody can help me please?. ¿how can to look this information about clp?

Thank you for you help.

n_i · #4 (**permalink**) 02-04-12, 09:29

How to investigate poor query performance using section actuals - IBM DB2 9.7 for Linux, UNIX, and Windows

Internet Services

Web Development

Digital Marketing

Consumer Tech