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 buffer pool?
What is a collection in db2?
What is database alias db2?
What is ibm db2 client?
What is ibm db2 database?
How many databases are there?
What are the 2 sqlcodes that are returned?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to test SQL -911 error while developing COB-DB2 program
what are bind concepts in db2 cobol?
What is bind plan?
What is the use of db2 optimizer?
What is coalesce in db2?
What is db2 look?