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 with ur in db2?
Is db2 free?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is db2 look?
What is ibm db2 connect?
What are the 2 sqlcodes that are returned?
How to resolve deadlock issue
How does a cursor work?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is buffer pool and list some of them?
What is a page in db2?
What are iseries servers?
Explain about cursor stability?
Explain the function of data manager.
What is plan in cobol db2?