Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 7100 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shweta agarwal
access path can be viewed by specifying the EXPLAIN
Parameter in the bind JCL as YES..
synatx
EXPLAIN(YES).
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
Discuss about db2 bind?
How can record locking be achieved in those DB2 versions which do not support it?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the full forms of spufi and dclgen and why are they used?
What does db2 plan contain?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is reorg?
What is deadlock in db2?
What is the maximum number of columns in a db2 table?
What is the use of with ur in db2?
What does db2 mean?
What kind of database is db2?
What is db2 command?
Explain what are the various isolation levels possible?
