Re: Migration IDS 7.31 to 9.40

Here's something about our experience 1. BACKUP. Make absolutely sure that you carry out a quiescent backup immediately before the upgrade. We ran into issues during both our attempts (7.31FD4 -> 9.40FC2 on HPUX 11.11) - in the first attempt, we had to restore; in the second, Tech. support hacked one of the databases. 2. OPTIMIZER. The Optimizer (as can be expected) has been "improved". This means that some of your queries which were running fine may experience a slowdown. Our DSS system was affected just a bit; I suspect that an OLTP system (in which the Optimizer usually has less thinking to do) will be affected even less. However, ideally, test this out before-hand using real data as far as possible. 3. STORED PROCEDURES. Plan to recreate all SPs. v9.4 is less forgiving on syntax. For example, RETURNS was allowed in v7.3, but not in v9.4. Also, there are a few new keywords (like DATE, NAME, etc). The simplest solution is to extract the entire database schema and recreate it in a test environment well before the upgrade. The recreation will identify all SPs that need to be fixed. 4. MIGRATION document. Read it. There's stuff in there about "fixing tables with pending in-place alters", update statistics, etc. Finally, 9.4 is definitely worth it. Performance appears to be a lot better and the new features (even simple things like SPs being able to return column headings, longer object names) are great. All the best Rudy