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
What is dbrm? What it contains? When it will be created?
Is schema the same as database?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the difference between bind and rebind in db2?
How do I copy a table in db2?
What is innodb buffer pool?
Mention some fields that are a part of sqlca.
What is cloudant database?
What is load utility in db2?
What is access path in db2?
Can we delete records from view?
Explain about cursor stability?
How is deadlock resolved?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.