Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are PACKAGES ?

Answers were Sorted based on User's Feedback



What are PACKAGES ?..

Answer / rahul nittala

The concept of packages came from this particular problem
which was faced earlier:
when there were no packages, all the dbrms for a respective
program have to be bound directly to the plan. In such
cases, whenever there was any change made to any calling or
called program within the plan, all the modules had to be
bound to their individual dbrm and then all the dbrms had
to be bound to the plan. To avoid this, the concept of
package was introduced which was just an address location
in the memory and not a physical entity. By introducing the
package concept, it was not necessary to bind all the
individual dbrms again, only that module to which change
was done had to be bound to that respective package. There
will be a one - to - one relation between a dbrm and a
package. A package actually stores the address of the dbrm.

Is This Answer Correct ?    10 Yes 0 No

What are PACKAGES ?..

Answer / s

Packages are single bound DBRM. When there is an change
made to the application pgm, it requires only the bind of
the package as opposed to binding the whole plan if the
DBRM was directly bound to the plan.

Is This Answer Correct ?    6 Yes 0 No

What are PACKAGES ?..

Answer / deepak dada

packages is which contains the optimised path for
accessing the db2 packages cannt be executed by itself it
can be executed when is cotained in plan

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB2 Interview Questions

How would you print the output of an SQL statement from SPUFI?

2 Answers  


can we drop column from a table

7 Answers   INDUS,


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


what is the role of the cursor in db2?

0 Answers  


What is database manager in db2?

0 Answers  


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  


Is Cursor exicutable ?

3 Answers   TetraSoft,


how can i pull up a query which was previously stored in qmf

3 Answers  


Explain the contents that are a part of dclgen.

0 Answers  


What is cobol db2?

0 Answers  


What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  


Categories