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
- 8428 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 alias in db2?
When do you specify the isolation level?
i want to maintain uniqueness on pdf without make lf??????????
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Is schema the same as database?
What is the physical storage length of date data type?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What are db2 objects?
what is a corelated subquerry?
What is the role of data manager in the db2 database?
What do you mean by commit and rollback?
What is the difference between spufi and qmf?
What is syscat in db2?
What is a collection in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
