can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 6440 Views
- IBM, I also Faced
- E-Mail Answers
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
Mention data types used in db2 ?
How connect db2 database to datastage?
Discuss about db2 bind?
What is performance tuning db2?
what is utility for parm lib
What is the difference between cursor stability and repeatable read isolation levels?
What is a storage group (stogroup)?
What do you mean by cursor?
What is bind package and plan in db2?
What is data manager?
What is dbrm? When it will be created?
Which components manage deadlocks in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is db2 and what is the use of db2 optimizer?
What is cursor with hold option in db2?
