When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?
Answer Posted / 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 |
Post New Answer View All Answers
Explain about cursor stability?
Explain the contention situations caused by locks?
What is declare cursor?
What is cursor stability in db2?
Give the name of some fields form sqlca.
Is db2 relational database?
What is the latest version of ibm db2?
What is scrollable cursor in db2?
What is bufferpool in db2?
Which isolation level provides maximum concurrency?
What is the use of db2 optimizer?
Explain about rct.
What is dpf in db2?
Name the various locking levels available?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?