why db2 is called as universal database?what is the storage
capacity of db2v9 n what are the advantages of db2
- 3 Answers
- 8337 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest1
IBM developed the RDBMS that can be used in any platform.
Say in Mainframe, Windows, Unix. That why it is so call UDB.
Regarding the space I'm not sure.
Advantages:
1) Builtin security. (Like Grand&Revoke)
2) It provides logical & Physical data independency.
3) You need not open& close as what we are doing in files.
4) Sorts will be internally performed at DSN07DB.
5) Recovery will be easy(Using the utility)
6) you can also create View which are called virtual tables.
This also give greater security on your table.
The above mentioned are few advantages of db2.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What are the rules for db2 programming?
What is explain plan in db2?
What is the physical storage length of time data type?
B37 abend during spufi?
Discuss about db2 bind?
What is rebind in db2?
What is the use of dclgen in db2?
What is bind package and plan in db2?
What is the difference between using bind () and rebind () methods of naming class?
Mention the different locking levels that are available in db2.
How can we read records for specific member in CL? AND rpg?
What is runstats and reorg in db2?
Explain what are the various isolation levels possible?
How to find the maximum value in a column in the db2 database?
