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
List down the data types in the db2 database.
What os does db2 run on?
What is performance tuning db2?
On which levels locks can be applied?
What is the difference between dbm cfg and db cfg file in db2 ?
What are the 2 sqlcodes that are returned?
How to execute stored procedures?
What is the syntax for creating a table in the db2 database?
What is bufferpool in db2?
How to create db2 table in mainframe?
Why do we bind in db2?
What are the bind parameters ibm db2?
What is db2 look?
What is dclgen in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?