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
- 9330 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 to create backup table in db2?
What is dbrm in db2 database?
What is nvl in db2?
What are the bind parameters ibm db2?
Define declaration generator (dclgen).
What do you mean by commit and rollback?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is db2 command?
On which levels locks can be applied?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Explain correlated sub-queries.
What kind of database is db2?
What is a page in db2?
What is table space in db2?
What is db2 instance?
