What is a DB2 plan?

Answer Posted / ganesh

A db2 plan contains collections which in turn contains
packages.
A package contains the exectauble format of the sql
statements placed in the DBRM which was created during the
pre-comlie step.

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is declare cursor?

610


When do you specify the isolation level?

606


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2322


Which is faster delete or truncate?

673


What is a db2 cursor?

622






List out the buffer pools in db2

624


What is database reorganization?

587


What are concurrency issues?

626


What is db2 purescale?

543


How do I delete a column in db2?

676


What is runstats db2?

576


Explain packages.

658


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

642


List out the three types of page locks that can be held.

685


What is the difference between plan and package in db2?

568