Interested to Buy Any Domain ? << Click Here >> for more details...
What is the specific need of Plan and..where are the tables
in DB2 are physically saved
- 3 Answers
- 9258 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
What is schema in db2?
What is a cursor and what is its function?
What is coalesce in db2?
What is the function of the Data Manager?
What is a db2 collection?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
Q4. How will you get the count of record without using COUNT verb in query?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
How do you select a row using indexes in db2?
how to copy the host variables from ps file into cobol program other than include statement
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Explain the use of the WHERE clause?
COBOL 
