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


Please Help Members By Posting Answers For Below Questions

How does a cursor work?

558


What is ibm db2 connect?

575


What is drop table?

584


What are db2 tables?

649


What is the role of the data page in the db2 database?

589






SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10778


what is diffrence b/w file-aid tool and file-aid utility???

4183


How can you find out the # of rows updated after an update statement?

642


What is collection in db2 bind?

577


How do I delete a table in db2?

651


Explain the contention situations caused by locks?

594


What is the purpose of rollback and commit?

595


Outputs of explain are with matchcols = 0. What does this signify?

619


can we view the access paths created by dbrm ? how ? thx

6262


What is the usage of open cursor command?

601