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
- 8441 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 |
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What are the disadvantages of using VARCHAR?
How to create a table using embedded sql?
What is a clustering index?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How can we define a table? How can we apply SEARCH ALL on it ?
How do I copy a table in db2?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
i have a db2 variable how do u declare tht into working storage section ?
wht is d/f between union and joins ?
Can a Db2 table data be retrived through JCL?
COBOL 
