can we view the access paths created by dbrm ? how ? thx
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 tablespace?
What is a synonym ?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is dpf in db2?
Is db2 a mainframe?
Explain the use of the WHERE clause?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is sqlca?
How do you define a correlated name?