Where are plans stored?

Answer Posted / s

The Bound plans are stored in the SKCT tablespace in
DSNDB01 directory.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is consistency token in db2?

644


What is the difference between spufi and qmf?

641


When the like statement is used?

640


What is nvl in db2?

630


What is cascading rollback?

625






In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

646


What is precompiler in db2?

589


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1823


Explain about cursor stability?

625


How to find the maximum value in a column in the db2 database?

614


Which are the db2 tools to protect integrity of the database?

692


What are the uses of db2 optimizer?

819


What is the role of union all and union

652


What are foreign keys in db2?

616


What parameters are used to control the free space in DB2?

645