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 do I delete a table in db2?

634


Explain the benefits you can get from mainframe connect?

512


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

696


What is a db2 collection?

595


What are the bind parameters ibm db2?

613






On which levels locks can be applied?

645


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1222


What action db2 takes when a program aborts in the middle of a transaction?

643


What is bind and rebind in db2?

634


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

604


Explain the contents that are a part of dclgen.

646


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

625


What is db2? Explain.

593


How to compare data between two tables in db2?

648


What are the various data types available in db2?

624