When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shankar v
All Package related information are found in
SYSIBM.SYSPACKAGES catalog.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / guest
The executable version of the package that will be loaded
in to the EDM pool resides in the DSNDB01 directory in SKPT
table. All information about the package is stored in the
DB2 catalog table, SYSIBM.SYSPACKAGE.
Is This Answer Correct ? | 0 Yes | 0 No |
The only place of VSAM KSDS in DB2 is?
What is clone table?
What is null value in db2?
What is the purpose of using commit?
How will you return the number of records in table?
How do you retrieve the data from a nullable column?
What are the various isolation levels possible?
How to resolve -917 sql code in DB2?
what is the difference between join and union?
What is bind plan?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is reorg in DB2