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
Are views updateable?
What is commit in db2?
Name the various locking levels available?
How do we specify index to include or not during bind process.
How do I import a csv file into db2?
What happens in bind step in a db2 program?
What is bind in db2?
Is ibm db2 free?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are the benefits of using the db2 database?
Is db2 a database?
What is the function of logging in the db2 database?
How do you eliminate duplicate values in db2?
What are iseries servers?
What is explain in db2?