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 is index in db2?

What is null value in db2?

pls tell me abt the normalization five types....

What is buffer pool?

What is the difference between db2 and oracle?

How to check table size in db2 sap?

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

What are the Isolation levels possible ?

What is referential integrity?

What is image copy in db2?

what happend with out using Commit,when closing cursor and program?

For more DB2 Interview Questions Click Here