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
- 8541 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What kind of database is db2?
What is db2 and what is the use of db2 optimizer?
What is the reason behind not using select * in embedded sql programs?
What is the difference between bind and rebind in db2?
What is release/acquire in bind?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is rct?
How would the varchar column remarks defined?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a buffer in memory?
What is isolation level in db2?
What is with ur in db2?
What are db2 tables?
Mention the definition of cobol in varchar field.
What does reorg do in db2?
