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...

When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?

Answer Posted / s

Package is a single bound DBRM which contains the SQL
statements of a single application program or subroutine.
The package is a executable internal code that contains
access paths computed by the optimizer.
Bound packages are stored in SPT01 tablespace of the
DSNDB01 directory.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the sqlcode -501

12917


Which component is used to execute the sql statements?

1053


What is iseries database?

990


How is a typical db2 batch pgm executed?

1109


What is the maximum number of columns in a db2 table?

1214


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167


What is the difference between drop table and delete table?

1117


What is coalesce in db2?

1055


What is dbrm library?

999


How do I import data from excel to db2?

1011


How to check sequence on a table in db2?

994


What is a storage group (stogroup)?

1189


Which isolation level provides highest data integrity?

1039


Explain about cursor stability?

981


What is dbrm in db2 database?

1032