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
What is image copy in db2?
What is database manager in db2?
what is db2 restart?
What is the use of predicate?
What are types of indexes?
What is the latest version of ibm db2?
What is db2 bind?
What is dpf in db2?
Is db2 a mainframe database?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is release/acquire in bind?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the physical storage length of timestamp data type?
How to check last update on table in db2?