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
- 9054 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kumar
The first answer talks about the codes rule.
When you look at the error message/SQL status, which
carries same information accross mainframe, windows UNIX.
this could be the reason. Suggestions please
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ankit chourasia
because this database is so flexible that it can support any high level language. and also its access criteria is so vast and fast that it produces wonders ..............its a super computer i call
| Is This Answer Correct ? | 0 Yes | 1 No |
What is copy pending status in db2?
Write a query to extract first 5 characters of a name in the column Stud_Name?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is explain plan in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is meant by isolation level?
Give a brief description of db2 isolation levels?
What is cursor stability?
What is runstats utility in db2?
What are the contents of dclgen?
how do u update the faltfile into db2 table ?
What action db2 takes when a program aborts in the middle of a transaction?
COBOL 
