Interested to Buy Any Domain ? << Click Here >> for more details...
how to u check the query is executing or not ?where will u check for sqlcode ?
- 6 Answers
- 12817 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
Explain the benefits you can get from mainframe connect?
What are concurrency issues?
What does reorg do in db2?
Explain about cursor stability?
What is bufferpool in db2?
What kind of database is db2?
What is cobol db2?
How can you find out the # of rows updated after an update statement?
Can we delete records from view?
What is a db2 table?
What is host variable?
What is the latest version of ibm db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Mention the definition of cobol in varchar field.
Mention the downsides of page level lock.
