Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


can we view the access paths created by dbrm ? how ? thx

Answers were Sorted based on User's Feedback



can we view the access paths created by dbrm ? how ? thx..

Answer / 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

can we view the access paths created by dbrm ? how ? thx..

Answer / 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

More DB2 Interview Questions

what is the soft code for deadlock ?

2 Answers   Logica CMG,


What is cascading rollback?

0 Answers  


Can you Average the Characters ?

3 Answers  


What is cursor with hold option in db2?

0 Answers  


How to create a table using embedded sql?

1 Answers  


What is phantom read in db2?

0 Answers  


What is the result of open cursor statement?

0 Answers  


what is sql abend code -801,-802?

2 Answers  


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  


What does the RUNSTATS Utility do?

4 Answers  


Define buffer pool.

0 Answers  


Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,


Categories