how to u check the query is executing or not ?where will u check for sqlcode ?
- 6 Answers
- 11645 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / arun
If you want to check from DBA point of view.
I would suggest if the query is taking longer time you can
use any of the tools like detector and check how long the
query is running and how much cpu has been allocated to
this thread and how many get pages has been done how many
rows has been selected or inserted or updated.
We have tools to know the current status of the query.
If the query is simple and completes quickly SQL RC = 0 is
for the normal completion of the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does reorg do in db2?
What are packages in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is access path in db2?
What is the use of dclgen in db2?
What os does db2 run on?
What is an instance in db2?
Explain about rct in db2?
What is a storage group (stogroup)?
What is runstats utility in db2?
What is performance tuning db2?
Mention the definition of cobol in varchar field.
What is data manager?
What is meant by explain?
How do you find the maximum value in a column in db2?
