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



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

Post New Answer

More DB2 Interview Questions

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  


Why cursor is used in db2?

0 Answers  


how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


What will the DB2 optimizer do?

2 Answers  


What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  






What happens to a cursor after a commit?

3 Answers  


can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


Explain about rct.

0 Answers  


For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  


What is dclgen in db2?

0 Answers  


What is netezza database?

0 Answers  


Categories