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
What is db2 purescale?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the function of logging in the db2 database?
What is db2 instance?
What are foreign keys in db2?
Is ibm db2 open source?
Define declaration generator (dclgen).
What is the difference between nvl and coalesce?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the purpose of rollback and commit?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What are types of indexes?
Which are the db2 tools to protect integrity of the database?
How many databases can be created inside an instance in db2 ?