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 is difference between rollback and commit?
How do you eliminate duplicate values in db2?
Which isolation level provides maximum concurrency?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the difference between using bind () and rebind () methods of naming class?
Name the various locking levels available?
When reorg is used?
what are bind concepts in db2 cobol?
What is db2 bind process?
What is meant by explain?
How can you find out the # of rows updated after an update statement?
Explain db2.
What is the reason behind not using select * in embedded sql programs?
What is copy pending status in db2?
what is a corelated subquerry?