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
What is the syntax for seeing the columns and data types of a table in the db2 database?
Explain about mirror activator disk mirroring?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is db2 and what is the use of db2 optimizer?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Mention the definition of cobol in varchar field.
What action db2 takes when a program aborts in the middle of a transaction?
How to retrieve rows from a db2 table in embedded sql?
what are bind concepts in db2 cobol?
Name the various locking levels available?
What is the syntax for FETCH in DB2 ?
What is database reorganization?
What does db2 plan contain?
What is the difference between dbm cfg and db cfg file in db2 ?
What is the use of with ur in db2?