Upgrade IDS 9.21 to IDS 10.0
Wayne asked about problems upgrading IDS 9.21 to 10.0 on Solaris 2.8. Davorin Kremenjas, who moved from 9.40, reported statement cache bugs (workaround: disable SSC) and stored procedure plans needing UPDATE STATISTICS FOR PROCEDURE. David recommended dropping triggers and procedures, upgrading, recreating them, then running Art Kagel's dostats. Davorin keeps definitions in version control.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi all, I am planning to upgrade IDS 9.21 to IDS 10.0 on Sun Solaris 2.8 platform. I know IDS 9.21 is already end of services. I wonder if anyone has done this before and run into any problems I should be aware of it. If you have any tricks or tips would like to share, I would be appreciated. Thank you in advance. --Wayne
Well, I've migrated from 9.40, not 9.21, to 10.00. I've had problems with statement cache (known bug still not solved; workaround: disable SSC), and with execution plans for stored procedures, but that was probably my fault, I didn't stick to migration procedure to the letter (forgot to do "update statistics for procedures"). That's all I've encountered up till now and it's been three weeks since I've migrated. Hope this helps. <ngte4-db@yahoo.com> wrote in message news:1127508096.125699.184380@g14g2000cwa.googlegroups.com... > Hi all, > > I am planning to upgrade IDS 9.21 to IDS 10.0 on Sun Solaris 2.8 > platform. I know IDS 9.21 is already end of services. > > I wonder if anyone has done this before and run into any problems I > should be aware of it. > > If you have any tricks or tips would like to share, I would be > appreciated. Thank you in advance. > > --Wayne >
i would - drop triggers - drop stored procedures UPGRADE - create stored procedures - create triggers - update stats using Art Kagels dostats tool how long can the drops and recreates take if it is scripted?
Is this a reply on Wayne's post or mine? Anyway, thanks for suggestions. We keep all original statements for creating/altering database objects in versioning system and in sync with the database. So it's very easy and fast to drop and create triggers and procedures. <david@smooth1.co.uk> wrote in message news:1127774145.652759.311520@o13g2000cwo.googlegroups.com... >i would > > - drop triggers > - drop stored procedures > > UPGRADE > - create stored procedures > - create triggers > - update stats using Art Kagels dostats tool > > how long can the drops and recreates take if it is scripted? >