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
- 9311 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
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What's The Percentage Free Space ?
What is iseries database?
Define sqlca.
What is bind and rebind in db2?
What is lock escalation in db2?
What are the uses of db2 optimizer?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How many types of page locks can be held in db2?
Explain the benefits you can get from mainframe connect?
What is table space in db2?
What is the latest version of ibm db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
