can we view the access paths created by dbrm ? how ? thx

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you eliminate duplicate values in db2?

694


How to restart a DB2 program?

1372


What is the advantage in De-normalizing tables in DB2?

758


How to find the number of rows in a db2 table?

652


Explain correlated sub-queries.

591






what is db2 restart?

1701


How to fetch the last row from the table in SQL (db2)?

1043


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

637


What is reorg and runstats in db2?

702


B37 abend during spufi?

990


Which isolation level provides maximum concurrency?

672


What happens in bind step in a db2 program?

574


what are bind concepts in db2 cobol?

655


What is cursor stability in db2?

819


How do I import a csv file into db2?

571