What is the specific need of Plan and..where are the tables
in DB2 are physically saved
- 3 Answers
- 7657 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
How do I add a column to an existing table in db2?
what is the sqlcode -501
Describe major components of db2?
Explain the benefits you can get from mainframe connect?
Which command is used to remove all rows from a table?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is clone table?
What is host variable?
List down the data types in the db2 database.
What is innodb buffer pool?
What is host variable in db2 cobol?
is it compulsory commitment control in journal?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
On which levels locks can be applied?
Can there be more than one cursor open for any program?
