Interested to Buy Any Domain ? << Click Here >> for more details...
why db2 is called as universal database?what is the storage
capacity of db2v9 n what are the advantages of db2
- 3 Answers
- 9050 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
What is a dbrm in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the max length of sqlca?
What is explain in db2?
What is the difference between oracle and db2?
What is with ur in db2?
Explain the contention situations caused by locks?
Define db2 and its databases?
What is null value in db2?
Why do chiropractors use drop table?
How do I delete a table in db2?
What is db2 plan table?
What is the physical storage length of timestamp data type?
What is reorg?
What is database reorganization?
