Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 7104 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 will the COMMIT accomplish?
can any body explain about plan and pakage in detail....
difference between group clause and order clause
max number of columns in a db2 table?
Can we install 2 different versions of Db2 on same mainframe?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
How can you compare table column after update and before update?
what is + sign and -ve sign for sql code ?
What is package in db2 mainframe?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Name the various locking levels available?
How would you print the output of an SQL statement from SPUFI?
COBOL 
