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 ?||10 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
correct me if i am wrong
|Is This Answer Correct ?||10 Yes||1 No|
Answer / srinvias yadav
PLAN IS AN EXECUTABLE ONE.
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|
When do you specify the isolation level?
What happens to a cursor after a commit?
What is the syntax required for the creation of a cursor?
How to know the primary key of a table without defining the primary key in the table?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How do I import a csv file into db2?
What is index in db2?
how can we find nth max salary from A table
Name the different types of Table spaces.
What are packages in db2?
What is an access path?