When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?
Answers were Sorted based on User's Feedback
Answer / s
Package is a single bound DBRM which contains the SQL
statements of a single application program or subroutine.
The package is a executable internal code that contains
access paths computed by the optimizer.
Bound packages are stored in SPT01 tablespace of the
DSNDB01 directory.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / shankar v
All Package related information are found in
SYSIBM.SYSPACKAGES catalog.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What are the three lock types?
In terms of DB2 indexing, what is the root page?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
When do you use the IMAGECOPY?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What is the function of the Data Manager?
Explain about rct.
Can one database have multiple instances?
What is db2 plan table?
What is correlated subquery?
What is the maximum length of sqlca?