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
- 8864 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 are db2 objects?
What is sqlca’s maximum length?
What are concurrency issues?
Why do we use cursor?
What kind of database is db2?
What r the comman abends in db2, jcl and cobol???????
List out the three types of page locks that can be held.
Are view updateable?
What does db2 stand for?
What is the difference between cursor stability and repeatable read isolation levels?
How to fetch the last row from the table in SQL (db2)?
What is the use of db2?
What does runstats do in db2?
What is difference between alias and synonym in db2?
i want to maintain uniqueness on pdf without make lf??????????
