Answer / kamal

plan is an optimized access path,but it is an executable component,package contains optimized access path,which is generated by optimizer of bind & it is a non-executable component.

Answer / sridhar reddy

When ever a main progran is executed it is going to create
a DBRM for example if the main program calls n sub programs
then these n sub program need N DBRM's A total of N+1 DBRMs
are needed. A Plan is required to run These DBRM's .
Instead of placing all these DBRM's in a plan , for each
DBRM one package is created & these packages inturn call a
plan.
Instead of placing DBRM's in a plan a package is created
because if we modify any thing no need recompile all the
DBRM's
posted by Sridhar BhumiReddy

Answer / vamsi

Plan is an executabel one which provides access path to
access the DBRM's.

Answer / praveen

plan contains address of package.
package contains data set.

Answer / karthik

PLAN IS PLAN
PACKAGE IS NOT PLAN IS PACKAGE

How does coalesce work?

0 Answers  

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

When is the access path determined for dynamic SQL?

2 Answers  

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

What is innodb buffer pool?

0 Answers  

What is auditing?

2 Answers  

What is meant by AUTO COMMIT?

3 Answers  

What is a db2 schema?

0 Answers  

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,