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
- 8553 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 |
How to find schema of a table in db2?
How is deadlock resolved?
what is the process of precompiler?
What is the physical storage length of date data type?
what is consistency token
What is the maximum No of rows per page?
Name some fields from SQLCA.
List down the types of triggers in the db2 database?
When will you chose to run RUNSTATS?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
is it compulsory commitment control in journal?
How to handle null values in db2
COBOL 
