Interested to Buy Any Domain ? << Click Here >> for more details...
What is the specific need of Plan and..where are the tables
in DB2 are physically saved
- 3 Answers
- 9122 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 difference between alias and synonym in db2?
What is precompiler in db2?
What are bind parameters in db2?
what are bind concepts in db2 cobol?
What is db2 command?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is meant by union and union all?
List down the data types in the db2 database.
What is the difference between dbm cfg and db cfg file in db2 ?
What is netezza database?
What does db2 blu stand for?
What r the comman abends in db2, jcl and cobol???????
Explain the contents that are a part of dclgen.
Can we update view in db2?
Which component is responsible for processing sql statements and selecting access paths?
