why db2 is called as universal database?what is the storage
capacity of db2v9 n what are the advantages of db2
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 cursor stability in db2?
What is Skeleton cursor table (SKCT)?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is dbrm? What it contains? When it will be created?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is a lock?
Explain about open switch business continuity software?
What is a correlated sub query?
What is copy pending status in db2?
How does DB2 store NULL physically?
Describe what a storage group(STOGROUP) is?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.