Where is the access path logic created by the DB2 Optimizer
stored?



Where is the access path logic created by the DB2 Optimizer stored?..

Answer / s

It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More DB2 Interview Questions

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,


What is the latest version of ibm db2?

0 Answers  


Explain how can you do the explain of a dynamic sql statement?

0 Answers  






How to execute stored procedure in db2 command editor?

0 Answers  


What is catalog database in db2?

0 Answers  


what is the responsibility of the construction superintendent

0 Answers   Almco,


What is meant by the attachment facility?

3 Answers  


How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,


What is the difference between Primary key and unique index?

6 Answers  


What is a view? Why use it?

2 Answers  


Categories