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



why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advant..

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

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advant..

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

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advant..

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

Post New Answer

More DB2 Interview Questions

What is cursor stability in db2?

0 Answers  


What is Skeleton cursor table (SKCT)?

2 Answers  


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.

3 Answers   IBM,


What is dbrm? What it contains? When it will be created?

0 Answers  


which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,






What is a lock?

1 Answers  


Explain about open switch business continuity software?

0 Answers  


What is a correlated sub query?

2 Answers  


What is copy pending status in db2?

0 Answers  


How does DB2 store NULL physically?

2 Answers  


Describe what a storage group(STOGROUP) is?

2 Answers  


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.

1 Answers   Syntel,


Categories