What is the specific need of Plan and..where are the tables
in DB2 are physically saved
Answers were Sorted based on User's Feedback
Answer / srinivas chennareddy
Though the tables are stored logically in tables space and
physically all tables/table Spaces are stored in VSAM
files....so the ultimate pgysical storage of any database
object is a VSAM file.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / amit
plan is nothing but executable form of sql statements and
formed by one or more dbrms, it is used for run the program,
without plan it will not run.
physically tables are stored in table space of data base.
but the information of table is tabulated in system
table 'sysibm.systable'
correct me if i am wrong
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / 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 |
Name the various locking levels available?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
Why use RUNSTAT Utility?
What is the difference between Where and Having Clause
How do you prepare a COBOL + DB2 program from coading till execution ?
What is the difference between dbm cfg and db cfg file in db2 ?
What is a db2 collection?
What is the use of with ur in db2?
Q3. How will you fetch duplicate values from a DB2 table?
What is performance tuning db2?
What is coalesce in db2?
How to resolve -407 sql code in DB2?