How can you find out which query is taking lot of time to execute in cobol-db2 p

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

Question Posted / azharuddinsyed

How can you find out which query is taking lot of time to execute in cobol-db2 program ?..

Answer / basavaraj

Using bmc utlity we can find out

Is This Answer Correct ?

0 Yes

0 No

More DB2 Interview Questions

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

What is auditing?

How to find the number of rows in a db2 table?

what is the responsibility of the construction superintendent

What is check constraint in db2?

What is the difference between a package and a plan?

What is the STOSPACE Utility used for?

What is the difference between dbm cfg and db cfg file in db2 ?

Where would you find information about the type of database authority held by the user?

what is the use of cursors?

Why select is not preferred in embedded sql programs?

How will fetch last 5 rows from table in db2

For more DB2 Interview Questions Click Here