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

Answer Posted / basavaraj

Using bmc utlity we can find out

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What language is db2 written in?

595


Name the various locking levels available?

638


What is db2 and what is the use of db2 optimizer?

656


What is alias in db2?

572


What's The Error Code For Unique Index Voilation?

655






How to find primary key of a table in db2?

617


What is the difference between cursor and select statement?

617


What is difference between rollback and commit?

636


List down the data types in the db2 database.

638


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7519


What is clone table?

592


What is view db2?

626


What action db2 takes when a program aborts in the middle of a transaction?

659


What is null indicator in db2?

606


Explain about cursor stability?

625