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
- 8559 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 is the result of open cursor statement?
Which isolation level provides maximum concurrency?
What is access path in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Mention the location where the output received from explain statement is stored.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Mention the different locking levels that are available in db2.
what is db2 restart?
What is dclgen (declaration generator)?
How is a typical db2 batch pgm executed?
What is a db2 tablespace?
What is role in db2?
How can you do the explain of a dynamic sql statement?
What is the use of dclgen in db2?
What is database manager in db2?
