Where are plans stored?

Answer Posted / anand

SYSIBM.SYSPLAN

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the max length of sqlca?

755


What is null indicator in db2?

593


How do I add a column to an existing table in db2?

580


Define sqlca.

645


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

569






What is commit in db2?

588


What is db2 and what is the use of db2 optimizer?

644


How to fetch the last row from the table in SQL (db2)?

1027


Explain about rct in db2?

632


What are the full forms of spufi and dclgen and why are they used?

646


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

646


Explain the function done by data manager?

849


How do you concatenate the firstname and lastname from emp table to give a complete name?

595


What is access path in db2?

556


What is bind in db2?

599