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 difference between alias and synonym in db2?
How do I import data from excel to db2?
What is copy pending and check pending in db2?
What are concurrency issues?
Explain dclgen.
What is explain plan in db2?
What is query_cache_limit?
Name the various locking levels available?
How do I add a column to a table in db2?
What is the use of db2 optimizer?
What is precompiler in db2?
What is schema in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is the role of union all and union
What is the meaning concurrency in the db2 database?