Re: Migration IDS 7.31 to 9.40
Hi Rudy, Thanks a lot for your message. As your name - I guess - has 'Fernandes', I guess you are from Brazil, Portugal or some "Spanish" country, right ? Would you be kind and tell me from where you come from ? I'm Brazilian, I live in Saint Paul. I'm worried about "has no return's in SPs" on IDS 9.4x because, almost all applications are developed in SPs. We have more than 4700 SP in the main database. Thanks again. R. Ferronato RudyFernandes@yahoo.com (Rudy) wrote in message news:<3d531325.0403100419.6b8af2e4@posting.google.com>... > 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
Its RETURNS (with an S) that's allowed in v7.3, but not in v9.4. RETURN is allowed (crucial, actually) in both versions. Rudy (Canadian, Toronto) roeferr@ig.com.br (Ferronato) wrote in message news:<df1bdeb4.0403110626.5b891e1f@posting.google.com>... > Hi Rudy, > > Thanks a lot for your message. > As your name - I guess - has 'Fernandes', I guess you are from Brazil, > Portugal or some "Spanish" country, right ? > Would you be kind and tell me from where you come from ? > I'm Brazilian, I live in Saint Paul. > > I'm worried about "has no return's in SPs" on IDS 9.4x because, almost > all applications are developed in SPs. We have more than 4700 SP in > the main database. > > Thanks again. R. Ferronato > > RudyFernandes@yahoo.com (Rudy) wrote in message news:<3d531325.0403100419.6b8af2e4@posting.google.com>... > > 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