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


Please Help Members By Posting Answers For Below Questions

Are views updateable?

647


What is commit in db2?

596


Name the various locking levels available?

638


How do we specify index to include or not during bind process.

1674


How do I import a csv file into db2?

564






What happens in bind step in a db2 program?

569


What is bind in db2?

608


Is ibm db2 free?

577


What is the syntax for seeing the columns and data types of a table in the db2 database?

578


What are the benefits of using the db2 database?

662


Is db2 a database?

574


What is the function of logging in the db2 database?

645


How do you eliminate duplicate values in db2?

688


What are iseries servers?

569


What is explain in db2?

585