Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 7001 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 to identify the pseudo conversation by seeing the program
Which component is used to execute the sql statements?
How to find primary key of a table in db2?
what is the difference between join and union?
What does it mean if the null indicator has -1, 0, -2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
How to retrieve rows from a db2 table in embedded sql?
What is Call attach facility? How does it work?
How to find last record before record through SQLRPGLE?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How will you delete duplicate records from a table?
COBOL 
