Re: Any issues with Verion 5 to 7 Upgrades?

In article <rclineD9wGFx.D5y@netcom.com>, rcline@netcom.com says... > >My question, is, that since we are currently in a design phase >are there any issues that I should be aware of in converting from >Version 5 to 7. Prior to the conversion I hope that I receive the >V7 Manuals and we should have our first release of the Database >implemented for development and coding. Any pitfalls of enhancements >to V7 that I should be aware of that might affect my DB Design and/or >performance? If you are intending to use table fragmentation then make sure that you have at least double the amount of space available in the new dbspaces to build the tables. Version 7.1 requires a large overhead during the construction of the fragments. Other than that I found the process to be gratifyingly uneventful. The Migrating to DSA course run by Informix (Raj Murali) is well worth the money in my opinion. What level code are you running? If you move to 6.1 (4.13 codestring) there are issues to do with error trapping in construct statements, and display and prompt strings crashing programs if they are longer than the window they are displayed in. These are pretty well documented and if you are using 4.13 then you will already have covered them. > >One other , more generic question, this will be my first project >implementing multiple instances of INFORMIX On-Line. Since the V5 DBA >Manuals states that the initial configuration should use between 20 and 25% >of base memory, what would the memory requirements be for each additional >instance of the engine? > You might need to re-assess this. DSA has it's own context switching and now does nearly everything through shared memory. As a result you need a heap more shared memory but [it is claimed] overall memory usage is improved. Each instance will need it's own shared memory pool (IE, as if it was the only instance.). Memory is shared only within each instance. Good luck with your project. Regards