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
- 8918 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 |
How to run db2 command in windows?
Who uses db2?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
How do we specify index to include or not during bind process.
What is db2 instance?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What are db2 objects?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is the information associated with sysibm.syslinks table?
What is package in cobol db2?
What is lock contention?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
COBOL 
