Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 6996 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
How to check sequence on a table in db2?
How to connect to db2 database from windows command line?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is meant by explain?
How do I import a csv file into db2?
How would you find out the total number of rows in a db2 table?
What is drop table?
What does db2 mean?
What is lock escalation in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Which isolation level provides highest data integrity?
Define sqlca.
Define predicate?
What is database manager in db2?
