I think not possible. information about access path stored in database c

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

Question Posted / krishna

2 Answers
7002 Views
IBM, I also Faced
E-Mail Answers

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

What is db2?

1143

Explain package in db2 and its advantages?

1161

What is database alias db2?

1081

What is a bind in db2?

1003

Before you give the explain statement, what are the prerogatives?

990

How does coalesce work?

977

Define db2.

1075

What is db2 optimizer?

1201

Is ibm db2 open source?

1039

What are the 2 sqlcodes that are returned?

1155

Explain the contents that are a part of dclgen.

1048

How can we read records for specific member in CL? AND rpg?

664

What is a db2 cursor?

1022

Which command is used to remove all rows from a table?

1066

What is database manager in db2?

980