how to u check the query is executing or not ?where will u check for sqlcode ?
- 6 Answers
- 10710 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
How can you find out the # of rows updated after an update statement?
What is role in db2?
What is a db2 tablespace?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How does cobol compile db2 program?
Explain the function of data manager.
What is the use of commit in db2?
what is the role of the cursor in db2?
How do you stop a db2 database in linux?
What is the information associated with sysibm.syslinks table?
What is data manager?
How is a typical db2 batch pgm executed?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is copy pending status in db2?
