I need to move a database from sybase 11.5 on Aix 4.1.5 to Aix 4.5 and
Sybase 12.5.2.

I need to get some info about this.

Is this a straight upgrade or do I need to go in steps to intermediate
levels?

I can't seem to find a migration path anywhere so if someone can point
me to this I will appreciate it.

Thanks ,


Praim Sankar

"Praim Sankar" <psankar (AT) ibc (DOT) ca> wrote

I didn't even realise 12.5.2 was out. We're upgrading from 11.5 to 12.5 and
the upgrade is relatively straight-forward. Loading an 11.5 db into 12.5
will upgrade the db. The key things to note are:
1. Different directory structures. There's $SYBASE, then $SYBASE_ASE
2. Memory is changed a bit. "total memory"'s equivalent is now "max memory",
there's physical and logical memory, there's no proc cache % but a value and
you have to configure the "default data cache"
3. Extra rollback records means you should increase your log sizes from 11.5
4. Be sure to recompile all your stored proc after the upgrade
5. You can use update index stats instead of just update stats but it's more
tempdb intensive

Most stored procs will work fine but you should test them all anyway.

Btw, why aren't you upgrading to AIX 5?

Martin

Thanks for you response.

I am actually moving to AIX 5.

Martin Hanna wrote:

It's not officially "out" / "available" on CD, though it appears as a link already in https://sybase.subscribenet.com,
and there's already a 12.5.2 Core Documentation Set on manuals.sybase.com