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

Define sqlca.

729


Define check constraint.

721


What are host variables in db2?

709


What is the difference between drop table and delete table?

655


Can we delete records from view?

653






What is innodb buffer pool?

641


How do you stop a db2 database in linux?

640


What is cloudant database?

720


What is runstats and reorg in db2?

907


How to compare data between two tables in db2?

749


What is ibm db2 used for?

697


What is runstats utility in db2?

681


What is a db2 table?

685


What is db2 catalog database?

659


How can you count the number of rows from a table tab?

723