Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 7008 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 is the soft code for deadlock ?
What is cascading rollback?
Can you Average the Characters ?
What is cursor with hold option in db2?
How to create a table using embedded sql?
What is phantom read in db2?
What is the result of open cursor statement?
what is sql abend code -801,-802?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What does the RUNSTATS Utility do?
Define buffer pool.
Normalization in DB2 – first normal form, second normal form
COBOL 
