What is the specific need of Plan and..where are the tables
in DB2 are physically saved
- 3 Answers
- 7662 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / srinvias yadav
PLAN IS AN EXECUTABLE ONE.
I.E,
WHEN THE CONCEPT OF MAIN PROGRAM AND SUB PROGRAM IS THERE
THEN WE NEED PLAN.
IF THERE IS A SINGLE PROGRAM THEN PACKAGE IS EXECUTABLE ONE.
ALL THE DB2 FILES ARE SAVED IN TABLESPACES.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is temporal table in db2?
What is database alias db2?
What is syscat in db2?
What are the contents of a dclmgen?
Where do you specify them?
What is a system catalog table in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are the contents of dclgen?
What is view db2?
Explain the contents that are a part of dclgen.
What is dpf in db2?
What is dclgen in db2?
What is db2? Explain.
What is db2 optimizer?
