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

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


Which component is used to execute the sql statements?

0 Answers  


How to find primary key of a table in db2?

0 Answers  


what is the difference between join and union?

4 Answers   IBM,


What does it mean if the null indicator has -1, 0, -2?

1 Answers  


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  


If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


How to find last record before record through SQLRPGLE?

1 Answers   IBM,


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


How will you delete duplicate records from a table?

7 Answers   Google,


Categories