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
What is the default page size of buffer pools?
How to check sequence on a table in db2?
Which component is responsible for db2 startup and shutdown?
What is rebind in db2?
What is the difference between oracle and db2?
Explain the contents that are a part of dclgen.
How do I change the column size in db2?
i want to maintain uniqueness on pdf without make lf??????????
How do you concatenate the firstname and lastname from emp table to give a complete name?
Mention the different locking levels that are available in db2.
How to execute stored procedure in db2 command editor?
What's The Percentage Free Space ?
What is the picture clause of null indicator variable?
What is the difference between bind and rebind in db2?
If I have a view which is a join of two or more tables, can this view be updateable?