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 |
Explain the EXPLAIN statement?
Are views updatable ?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
How does db2 sample database connect?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
what is static sql? what is dynamic sql? Give me details
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What are PACKAGES ?
What is an instance database?