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

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


What is concurrency in db2?

1 Answers  


what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,


What is a dbrm in db2?

0 Answers  


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,






How many types of page locks can be held in db2?

0 Answers  


What is the difference between CS and RR isolation levels?

1 Answers  


What is the difference between base table and view?

7 Answers  


My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,


How to design maps

1 Answers   Virtusa,


What is the purpose of using commit?

0 Answers  


What is PRIME TABLE and what are the uses of it

1 Answers  


Categories