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 |
can we update the table by using cursors can anyone post the query?
What are the various data types available in db2?
Return code 100 means?
Explain correlated sub-queries.
What is cursor?
What is the size of a data page?
What does db2 mean?
what are bind concepts in db2 cobol?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is a db2 tablespace?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?