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
- 8900 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 is lock escalation in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is meant by explain?
Where can you declare a cursor in a cobol-db2 program?
What is cobol db2?
Name the lockable units in DB2?
How do I delete a column in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is reorg?
What is rebind in db2?
What is package in cobol db2?
What is dbrm in db2 database?
What is the maximum size of a char data type in db2?
What does db2 mean?
