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


Please Help Members By Posting Answers For Below Questions

What is difference between rollback and commit?

894


How do you eliminate duplicate values in db2?

912


Which isolation level provides maximum concurrency?

913


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

2017


What is the difference between using bind () and rebind () methods of naming class?

1091


Name the various locking levels available?

842


When reorg is used?

871


what are bind concepts in db2 cobol?

837


What is db2 bind process?

953


What is meant by explain?

866


How can you find out the # of rows updated after an update statement?

875


Explain db2.

822


What is the reason behind not using select * in embedded sql programs?

860


What is copy pending status in db2?

878


what is a corelated subquerry?

841