Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 6972 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 |
what are the SQL codes u freequently got?
Which catalog table stores referential constraints?
Which catalog tables contain authorization information?
How can we define a table? How can we apply SEARCH ALL on it ?
How to define the data items to receive the fetch items for the SQL?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is correlated subquery?
what is the responsibility of the construction superintendent
Explain what a plan is?
What is tablespace?
What is a cursor?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
COBOL 
