Interested to Buy Any Domain ? << Click Here >> for more details...
When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?
- 3 Answers
- 8450 Views
- I also Faced
- E-Mail Answers
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 |
define clustering index.
Explain the use of the WHERE clause?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What does a deadlock mean in DB2?
What is index in db2?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
When is the access path determined for dynamic SQL?
How can you find out the # of rows updated after an update statement?
What happens in bind step in a db2 program?
how do u update the faltfile into db2 table ?
How many buffer pools are available in db2?
What is the logical entity between plan and Package?
COBOL 
