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
- 13003 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 is db2 bind?
What are the benefits of using the db2 database?
What are the prerogatives?
Outputs of explain are with matchcols = 0. What does this signify?
How to check table size in db2 sap?
What kind of database is db2?
What is the use of reorg in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Explain correlated sub-queries.
Is ibm db2 open source?
What is ibm db2 database?
What is db2 purescale?
What are the two types of logging in the db2 database? Explain them.
How to get the ddl of a table in db2?
How to test SQL -911 error while developing COB-DB2 program
