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
How do I delete a table in db2?
Explain the benefits you can get from mainframe connect?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is a db2 collection?
What are the bind parameters ibm db2?
On which levels locks can be applied?
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.
What action db2 takes when a program aborts in the middle of a transaction?
What is bind and rebind in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Explain the contents that are a part of dclgen.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is db2? Explain.
How to compare data between two tables in db2?
What are the various data types available in db2?