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 is plan? is plan executable or package?

What is bind plan?

What is sqlca?

How do you run JCL in cobol program

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

What is buffer pool in the db2 database?

Which catalog table stores referential constraints?

is it compulsory commitment control in journal?

Why do we use cursor?

What is the picture clause of the null indicator variable?

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

What is an asychronous write?

For more DB2 Interview Questions Click Here