Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

can any body explain about plan and pakage in detail....

Answers were Sorted based on User's Feedback

can any body explain about plan and pakage in detail......

Answer / ashish kumar

A DB2 bind is a process that builds an access path to DB2

A BIND process establishes a relationship between an APPLICATION
A plan is an executable module containing the access path logic
produced by the Db2 optimizer. It can be composed of one or
more DBRMs and packages.
The plans are available in the Catalog table SYSIBM.SYSPLAN

DB2 Bind compiles all your sql statements(dbrm) into an
executable format.
It uses DB2 Optimizer to create the better access path.
Package is the executable access path code for the sql
statements in the DBRM

Plan contains package list which is nothing but pointers to

Is This Answer Correct ?    13 Yes 0 No

can any body explain about plan and pakage in detail......

Answer / srinivasa gudla

A package is single bound DBRM with optimized access paths.
It contains location identifier, collection Identifier and
package identifier.

A package can have multiple versions, each with it's own
version identifier

Advantages of Packages,
Reduce the Bind Time.
Can provide BIND options at programmer level.

As Ashish mentioned above, Plan contains packages list which
is nothing but Pointers. whenever you are doing changes in
SQL staetments related to particular DBRM . Then only that
particular Packages needs to be rebind not the Plan. This is
similar to recompiling a sub program not the main program.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB2 Interview Questions

what is plan? is plan executable or package?

4 Answers  

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 to write query for this..

1 Answers   HSBC,

wht are the restrictions for union ?

2 Answers   CTS,

What are PACKAGES ?

3 Answers  

What are common abends

1 Answers   SPIC, Virtusa,

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

Why cursor is used in db2?

0 Answers  

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

What is schema in db2?

0 Answers