Best Practices /documents for upgrading to ASE 15.7

[james_morrison]

We are planning to upgrade our ASE and Replication Servers to 15.7

Current ASE servers are at 15.5 -- Replication Server 15.6

All hosts currently running Linux RHEL 6

Looking for any best practice strategies / documents   (i.e any gotchas or areas of concern after upgrading)

Plan is to upgrade in place

Also which SP level is recommended to apply  (SP100,121 ...)

Thanks

[Former Member · Accepted solution]

Hi,

I can't help with best practice or documents but can share my experience.

15.5 -> 15.7 for us has been painless. (12.5 -> 15.5 was rather harder) and no problem doing this in-place (Obviously you should still test it first)

The only issue we've found (excluding the usual query plan changes which occur in daily life anyway)

was that 15.7 doesn't allow 2 columns to be returned with the same name.

eg select x.*, y.* from x, y (and x and y tables both contain the same column name)

As part of the upgrade we also moved to 16k pages. If you're using SANs its a major improvement.

Note: when we benchmarked the threading model - we found better performance but when we used it in the real world it all stopped working. We think we mis-configured it sowe're aiming to try this again next month.

[james_morrison · Accepted solution]

Thanks Mike

That is helpfull

[Former Member · Accepted solution]

Just to add we've had 2 successful migrations from 15.5 -> 15.7 will no issues whatsoever and yet a third one we're having to rollback.

As always with any major software change - anything can happen 😉