What is the specific need of Plan and..where are the tables
in DB2 are physically saved
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 declare cursor?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the max length of sqlca?
How do I optimize a query in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Explain package in db2 and its advantages?
List down the data types in the db2 database.
What is coalesce in db2?
Explain the contention situations caused by locks?
What are the different types of base tables?
Define db2.
What do you mean by rollback?
What parameters are used to control the free space in DB2?
What is ibm db2 database?
Who uses db2?