Re: Oracle & Informix connectivity/coexisting issues question

In article <330C90C4.13B7@ix.netcom.com>, Will Rosales <will.r@ix.netcom.com> writes >Currently, I am running Informix Online DSA v7.21 on HPUX10.10 and soon >migrating to v7.22 >HPUX10.20. Our applications are developed in PowerBuilder v5 and >MicroFocus Cobol v10. >I am looking into installing Oracle for the first time on the same HP >server or maybe a separate >server. >1. When Oracle and Informix rdbms are both online, what is the >technique/configuration/software >and additional hardware if any needed to connect to both from the same >applications running on >NT and Unix? >2. Is this a simple or complex environment to implement, integrate, and >maintain? Complex, 2 sets of configuration, 2 sets of tuning (also when tuning Informix you need to consider resource utilisation by Oracle and vice versa..E.g. balancing disk I/O across devices). Also how will you handle backups (2 seperate tape devices)? How will you handle backups of transaction logs (2 more seperate tape devices)? >3. What troubles or issues are typically encountered? >4. Does Informix or Oracle provide assists for database access in a mixed >database environment? Each supports their own product and ignores the other one. >5. Where can I find a good reference guides/sources on this topic? >6. Any added helpful comments are appreciated. >Thanks for your interest and help. -- David Williams