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.googlegr oups.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.googlegr oups.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?
>