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 sqlca?
How does coalesce work?
What is a plan and package in db2?
What is null indicator in cobol db2?
How to run db2 command in windows?
Explain the contents that are a part of dclgen.
How do I change the column size in db2?
How does a cursor work?
What types of tables are there in the db2 database?
How can we retrieve the total number of records in RPG & CLLE?
Define data page.
what is a corelated subquerry?
Which are the db2 tools to protect integrity of the database?
What is cursor in dbms?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.