why db2 is called as universal database?what is the storage
capacity of db2v9 n what are the advantages of db2
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 the contents of a dclmgen?
What is commit in db2?
What is host variable?
Is the primary key a clustered index?
What happens in bind step in a db2 program?
How to run db2 command in windows?
What does runstats do in db2?
What r the comman abends in db2, jcl and cobol???????
What is the difference between db2 and oracle?
What is a cursor in programming?
What types of tables are there in the db2 database?
How do I start db2 in windows?
What is db2 command?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is performance tuning db2?