can we view the access paths created by dbrm ? how ? thx
Answer Posted / shweta agarwal
access path can be viewed by specifying the EXPLAIN
Parameter in the bind JCL as YES..
synatx
EXPLAIN(YES).
Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
Is db2 a mainframe database?
What is bind package and plan in db2?
define clustering index.
List out the data types available.
What is innodb buffer pool?
What is a db2 tablespace?
What is the physical storage length of the data types date, time, and timestamp?
How do I delete a column in db2?
What is a system catalog table in db2?
What is deadlock in db2?
What is bufferpool in db2?
Explain in brief how does db2 determine what lock-size to use?
What is db2 instance?
What's The Percentage Free Space ?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?