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
How do I create a view in db2?
What is a system catalog table in db2?
Are views updateable?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is db2 plan table?
Mention the downsides of page level lock.
How to get the ddl of a table in db2?
What does reorg do in db2?
Can you use max on a char column?
What is buffer pool?
What is a bind card?
How is the value function used?
What does db2 plan contain?
How do I start db2 in windows?
What is collection in db2 bind?