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?

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

What does db2 blu stand for?

What is the use of with ur in db2?

What is the difference between a package and a plan?

Is ibm db2 open source?

What is copy pending status in db2?

How do you do the EXPLAIN of a dynamic SQL statement?

What Utility is used to migrate DB2 from one release to the next?

What is the difference between static and dynamic SQL?

What does the CHECK Utility do ?

For more DB2 Interview Questions Click Here