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

1 Answers
3651 Views
Danske, I also Faced
E-Mail Answers

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 is the role of schema in the db2 database?

0 Answers

What is SPUFI?

4 Answers

db2 restart logic ?

1 Answers DELL, HTC, UHG,

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers Accenture,

What is a page?

2 Answers

How can you compare table column after update and before update?

5 Answers Satyam,

What is temporal table in db2?

0 Answers

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers IBM,

What is a buffer in memory?

0 Answers

What is ibm db2 used for?

0 Answers

For more DB2 Interview Questions Click Here