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 sqlcode -501
Which component is used to execute the sql statements?
What is iseries database?
How is a typical db2 batch pgm executed?
What is the maximum number of columns in a db2 table?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the difference between drop table and delete table?
What is coalesce in db2?
What is dbrm library?
How do I import data from excel to db2?
How to check sequence on a table in db2?
What is a storage group (stogroup)?
Which isolation level provides highest data integrity?
Explain about cursor stability?
What is dbrm in db2 database?