Answer Posted / mehdee
Collection is not an actual, physical database object.
Collection is a grouping of DB2 packages.
All packages reside in administrative units called
collections.
PLAN is an executable module containing the access path
logic to one or more DBRMs
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Explain correlated sub-queries.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain various types of locks in db2?
How to find the maximum value in a column in the db2 database?
Can one database have multiple instances?
How does db2 sample database connect?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What happens in bind step in a db2 program?
How is deadlock resolved?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
List out the data types available.
What is universal database?
What do you mean by commit and rollback?
What os does db2 run on?