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
- 9024 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 a db2 package?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is role in db2?
What is the result of open cursor statement?
Explain in detail about buffer manager and its functionalities?
What is rebind in db2?
How do I connect my db2 database to ibm?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How does coalesce work?
What is the purpose of using commit?
What is package in cobol db2?
What is table space in db2?
Is db2 a mainframe database?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How do I change the column size in db2?
