can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 6439 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 maximum No of rows per page?
how to take the back up of the DB2 table.
What is a page?
what types of copies can be made with the COPY Utility ?
what is cursor stability?
When would you prefer to use VARCHAR?
What is query for your birthday date should be in hours,minute and seconds format?
What does DML stand for and what are some examples of it?
What is REORG? When is it used?
can we view the access paths created by dbrm ? how ? thx
What is bind in db2?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
COBOL 
