What is the specific need of Plan and..where are the tables
in DB2 are physically saved
- 3 Answers
- 7243 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / amit
plan is nothing but executable form of sql statements and
formed by one or more dbrms, it is used for run the program,
without plan it will not run.
physically tables are stored in table space of data base.
but the information of table is tabulated in system
table 'sysibm.systable'
correct me if i am wrong
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is nvl in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How to execute stored procedures?
What is the role of data manager in the db2 database?
What is multi row fetch in db2?
What are packages in db2?
What is a db2 cursor?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
List out the three types of page locks that can be held.
What is release/acquire in bind?
What is db2 command?
What is host variable in db2 cobol?
Is db2 a database?
Why do chiropractors use drop table?
What db2 400?
