Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



What is the specific need of Plan and..where are the tables in DB2 are physically saved..

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

What is the specific need of Plan and..where are the tables in DB2 are physically saved..

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

What is the specific need of Plan and..where are the tables in DB2 are physically saved..

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

Post New Answer



More DB2 Interview Questions

When do you specify the isolation level?

0 Answers  


What happens to a cursor after a commit?

3 Answers  


What is the syntax required for the creation of a cursor?

1 Answers  


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


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 .....

0 Answers  






How do I import a csv file into db2?

0 Answers  


What is index in db2?

1 Answers  


how can we find nth max salary from A table

5 Answers   IBM,


Name the different types of Table spaces.

5 Answers   IBM,


What are packages in db2?

0 Answers  


What is an access path?

3 Answers  


Explain dclgen.

0 Answers  






Categories