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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the benefits you can get from mainframe connect?

514


Is ibm db2 free?

566


What is copy pending and check pending in db2?

567


what is the responsibility of the construction superintendent

1652


Who uses db2?

565






What is db2 plan table?

608


What are the two types of logging in the db2 database? Explain them.

566


Explain dclgen.

712


What are catalog tables in db2?

597


What is the picture clause of null indicator variable?

680


How to create db2 table in mainframe?

621


Why do we use cursor?

584


What is reorg?

610


What is coalesce in db2?

674


What is the advantage in De-normalizing tables in DB2?

733