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
- 8325 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 connect to db2 database from windows command line?
where can we use index and subscript ? with example ?
What is page size in db2?
Update command
How do you prepare a COBOL + DB2 program from coading till execution ?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What information is contained in a SYSCOPY entry?
Can we declare DB2 HOST variable in COBOL COPY book?
What are catalog tables in db2?
how to resolve -805 . how to see dbrm and package not found
What is DCLGEN?
What is bind package and plan in db2?
COBOL 
