Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 7054 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krishna
I think not possible. information about
access path stored in database catalog.
access path is stored in DB DIRECTORY, it can be used by
DB2 internally. no one can access the dB2 directory
if wrong please post right answer
| Is This Answer Correct ? | 1 Yes | 7 No |
How many types of page locks can be held in db2?
Which component is responsible for processing sql statements and selecting access paths?
Why db2 is called db2?
How do I import data from excel to db2?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What is a DB2 plan?
What is a subselect? Is it different from a nested select?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is a LIKE table and how is it created?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is explain in db2?
COBOL 
