When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shankar v
All Package related information are found in
SYSIBM.SYSPACKAGES catalog.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / guest
The executable version of the package that will be loaded
in to the EDM pool resides in the DSNDB01 directory in SKPT
table. All information about the package is stored in the
DB2 catalog table, SYSIBM.SYSPACKAGE.
Is This Answer Correct ? | 0 Yes | 0 No |
What is buffrpool? Where we use it ?
What is the difference between spufi and qmf?
How to create backup table in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How many databases can be created inside an instance in db2 ?
What is the syntax for FETCH in DB2 ?
What does DML stand for and what are some examples of it?
What is the role of schema in the db2 database?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is the difference between primary key & unique index ?
What are the various locking levels available?
What is the connection string to connect to the DB2 Database ?