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 type of database is db2?
Explain the function of data manager.
What is page size in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is a db2 package?
What are packages in db2?
List out the buffer pools in db2
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Which components manage deadlocks in db2?
Which are the db2 tools to protect integrity of the database?
Which command is used to remove all rows from a table?
How do I optimize a query in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is the maximum length of sqlca?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected