what are the possible disadvantages or advantages of choosing either DB2 or Oracle as the database structure?
Sid Adelmans Answer: More tools support Oracle than DB2. Data warehouse tool vendors usually support Oracle first, and these vendors usually have more experience with Oracle than with DB2. Oracle has a larger pool of DBA talent than DB2, and there are certainly more books written for Oracle than for DB2. Oracle is more expensive than DB2; DB2 software goes for significantly less. It usually takes fewer DB2 DBAs to support a database of comparable size and complexity. DB2 monitoring tools seem more mature and available than those for Oracle. IBM can provide more very large database references than Oracle can. Ive heard better stories of IBM support than support for Oracle but you should definitely check this out for yourself. David Marcos Answer: The first question is (obviously) are you a mainframe or a Unix shop today? If you are mainframe then its DB2, if you are Unix then Oracle or Informix. If you can go with either a mainframe or Unix, then you need to consider cost (Unix tends to
Related Questions
- Between which operating systems are homogeneous system copies and the structure of a standby database scenario possible?
- what are the possible disadvantages or advantages of choosing either DB2 or Oracle as the database structure?
- What are the advantages and disadvantages of converting to CDISC SDTM structure?
