I've seen different postings claiming that 11.0.3 can directly upgrade to
11.9.2.
However, the release bulletin for Sybase ASE 11.9.2 (Doc ID =
72410-01-1192-02)
says that "You can upgrade 11.9.2 only from  10.0.2.7, 11.0.3.3, 11.5 and
later).  We are
currently using 11.0.3.2.  Does it mean that I will have to upgrade our
server to 11.0.3.3
(from 11.0.3.2) before I can migrate to ASE 11.9.2?

I will appreciate if someone clarify this.

Thanks.

CGS
tcgs@hotmail.com

CGS wrote:
> 
> I've seen different postings claiming that 11.0.3 can directly upgrade to 11.9.2.
> However, the release bulletin for Sybase ASE 11.9.2 (Doc ID = 72410-01-1192-02)
> says that "You can upgrade 11.9.2 only from  10.0.2.7, 11.0.3.3, 11.5 and later)."

	Yeah, that's what it says.

> We are currently using 11.0.3.2.  Does it mean that I will have to upgrade our
> server to 11.0.3.3 (from 11.0.3.2) before I can migrate to ASE 11.9.2?

	Going from 11.0.3.2 to 11.0.3.3 is only a matter of installing
	an EBF. In other words, its relatively minor. But if its any consolation,
	I just upgraded from 11.0.2.2 to 11.9.2 without any problems (yet).

-am

Anthony Mandic wrote:
> 
> CGS wrote:
> >
> > I've seen different postings claiming that 11.0.3 can directly upgrade to 11.9.2.
> > However, the release bulletin for Sybase ASE 11.9.2 (Doc ID = 72410-01-1192-02)
> > says that "You can upgrade 11.9.2 only from  10.0.2.7, 11.0.3.3, 11.5 and later)."
> 
>         Yeah, that's what it says.
> 
> > We are currently using 11.0.3.2.  Does it mean that I will have to upgrade our
> > server to 11.0.3.3 (from 11.0.3.2) before I can migrate to ASE 11.9.2?
> 
>         Going from 11.0.3.2 to 11.0.3.3 is only a matter of installing
>         an EBF. In other words, its relatively minor. But if its any consolation,
>         I just upgraded from 11.0.2.2 to 11.9.2 without any problems (yet).
> 
> -am

The docs are a bit misleading, you can upgrade from any 10.0.2.x.
11.0.x, 11.5.x release to 11.9.2.

We have asked for the release bulletins to be updated to correct this,
but I do not believe that this has occured yet.

Regards,
lance
team sybase
-- 
===============================================================================
Lance J. Andersen			Email: lancea@sybase.com 
Sybase Product Support Engineering	Phone:(781) 564-6336 
77 South Bedford Street			Fax:  (781) 564-6148
Burlington, MA 01803                    

The Dark Knight Returns!!!              Let's Go Penguins!!!
===============================================================================

Lance Andersen wrote:
> 
> Anthony Mandic wrote:
> >
> > CGS wrote:
> > >
> > > I've seen different postings claiming that 11.0.3 can directly upgrade to 11.9.2.
> > > However, the release bulletin for Sybase ASE 11.9.2 (Doc ID = 72410-01-1192-02)
> > > says that "You can upgrade 11.9.2 only from  10.0.2.7, 11.0.3.3, 11.5 and later)."
> >
> >         Yeah, that's what it says.
> >
> > > We are currently using 11.0.3.2.  Does it mean that I will have to upgrade our
> > > server to 11.0.3.3 (from 11.0.3.2) before I can migrate to ASE 11.9.2?
> >
> >         Going from 11.0.3.2 to 11.0.3.3 is only a matter of installing
> >         an EBF. In other words, its relatively minor. But if its any consolation,
> >         I just upgraded from 11.0.2.2 to 11.9.2 without any problems (yet).
> 
> The docs are a bit misleading, you can upgrade from any 10.0.2.x.
> 11.0.x, 11.5.x release to 11.9.2.

	I suspected that might have been the case. My tests so far haven't
	revealed any problems. However, I didn't do an in-place upgrade
	but rather a new install with a load of database dumps from the
	old system.

-am

Anthony Mandic wrote:
> 
> Lance Andersen wrote:
> >
> > Anthony Mandic wrote:
> > >
> > > CGS wrote:
> > > >
> > > > I've seen different postings claiming that 11.0.3 can directly upgrade to 11.9.2.
> > > > However, the release bulletin for Sybase ASE 11.9.2 (Doc ID = 72410-01-1192-02)
> > > > says that "You can upgrade 11.9.2 only from  10.0.2.7, 11.0.3.3, 11.5 and later)."
> > >
> > >         Yeah, that's what it says.
> > >
> > > > We are currently using 11.0.3.2.  Does it mean that I will have to upgrade our
> > > > server to 11.0.3.3 (from 11.0.3.2) before I can migrate to ASE 11.9.2?
> > >
> > >         Going from 11.0.3.2 to 11.0.3.3 is only a matter of installing
> > >         an EBF. In other words, its relatively minor. But if its any consolation,
> > >         I just upgraded from 11.0.2.2 to 11.9.2 without any problems (yet).
> >
> > The docs are a bit misleading, you can upgrade from any 10.0.2.x.
> > 11.0.x, 11.5.x release to 11.9.2.
> 
>         I suspected that might have been the case. My tests so far haven't
>         revealed any problems. However, I didn't do an in-place upgrade
>         but rather a new install with a load of database dumps from the
>         old system.
> 
> -am

In place upgrades should be fine as well. One of my colleagues and I
cleaned up quite a few 'gotchas' in the external upgrade program.  We
have since backported these fixes to the latest flavors of 11.5.x and
11.0.3.3.

Hopefully this will make everyones lives a bit easier...

Lance
team sybase
-- 
===============================================================================
Lance J. Andersen			Email: lancea@sybase.com 
Sybase Product Support Engineering	Phone:(781) 564-6336 
77 South Bedford Street			Fax:  (781) 564-6148
Burlington, MA 01803                    

The Dark Knight Returns!!!              Let's Go Penguins!!!
===============================================================================

Anthony,
Upgrade in place is very similar to what happens when you
load an older DB into a newer server.  The online database
command enables the internal upgrade process triggered by 
the upgrade program, so really, not much happens "outside"
the ASE server upon running the upgrade in place.

John McVicker
Sybase Professional Services
Philadelphia, PA

Anthony Mandic wrote:
> 
> Lance Andersen wrote:
> >
> > Anthony Mandic wrote:
> > >
> > > CGS wrote:
> > > >
> > > > I've seen different postings claiming that 11.0.3 can directly upgrade to 11.9.2.
> > > > However, the release bulletin for Sybase ASE 11.9.2 (Doc ID = 72410-01-1192-02)
> > > > says that "You can upgrade 11.9.2 only from  10.0.2.7, 11.0.3.3, 11.5 and later)."
> > >
> > >         Yeah, that's what it says.
> > >
> > > > We are currently using 11.0.3.2.  Does it mean that I will have to upgrade our
> > > > server to 11.0.3.3 (from 11.0.3.2) before I can migrate to ASE 11.9.2?
> > >
> > >         Going from 11.0.3.2 to 11.0.3.3 is only a matter of installing
> > >         an EBF. In other words, its relatively minor. But if its any consolation,
> > >         I just upgraded from 11.0.2.2 to 11.9.2 without any problems (yet).
> >
> > The docs are a bit misleading, you can upgrade from any 10.0.2.x.
> > 11.0.x, 11.5.x release to 11.9.2.
> 
>         I suspected that might have been the case. My tests so far haven't
>         revealed any problems. However, I didn't do an in-place upgrade
>         but rather a new install with a load of database dumps from the
>         old system.
> 
> -am

John McVicker wrote:

> Upgrade in place is very similar to what happens when you
> load an older DB into a newer server.  The online database
> command enables the internal upgrade process triggered by
> the upgrade program, so really, not much happens "outside"
> the ASE server upon running the upgrade in place.

	Whilst this is true, the issue is a little more complex
	that that. I am thinking of the system databases in
	particular. The smaller device sizes of these databases
	in earlier server versions can be problematic, for example.

	I uncovered a problem last year with tempdb. A server at
	11.0.2.1 was upgraded to 11.5.1. It had the option "allow
	nulls by default" set in tempdb. This didn't cause a
	problem on that server, but when I created a new install
	of 11.5.1 and set that option in tempdb, PC clients would
	GPF in kernel32.dll with Infomaker. My assumption was that
	the databases themselves weren't entirely identical (or
	rather the model databases weren't entirely identical). I
	eventually got the developers to admit that the option wasn't
	required. Once turned off, the problem with Infomaker disappeared.

	I also recall a comment you made in a recent post about
	sysgams. All in all, I prefer to create new system databases
	and the load in the user databases (it also allows me to keep
	the old system databases in case I need to revert back to them).

-am

Lance Andersen wrote:

> In place upgrades should be fine as well. One of my colleagues and I
> cleaned up quite a few 'gotchas' in the external upgrade program.  We
> have since backported these fixes to the latest flavors of 11.5.x and
> 11.0.3.3.
> 
> Hopefully this will make everyones lives a bit easier...

	Out of curiosity, can you elaborate on the gotchas? I'm
	particularly interested in upgrades of the system databases.
	With the fixes, are we guaranteed that an upgraded master
	database would now be identical to a new installation
	(excluding user-added data, of course)?

-am

Anthony Mandic wrote:
> 
> Lance Andersen wrote:
> 
> > In place upgrades should be fine as well. One of my colleagues and I
> > cleaned up quite a few 'gotchas' in the external upgrade program.  We
> > have since backported these fixes to the latest flavors of 11.5.x and
> > 11.0.3.3.
> >
> > Hopefully this will make everyones lives a bit easier...
> 
>         Out of curiosity, can you elaborate on the gotchas? I'm
>         particularly interested in upgrades of the system databases.
>         With the fixes, are we guaranteed that an upgraded master
>         database would now be identical to a new installation
>         (excluding user-added data, of course)?
> 
> -am

Let me dig up the exact CR numbers and I will post them back here
tommorrow.

lance
team sybase
-- 
===============================================================================
Lance J. Andersen			Email: lancea@sybase.com 
Sybase Product Support Engineering	Phone:(781) 564-6336 
77 South Bedford Street			Fax:  (781) 564-6148
Burlington, MA 01803                    

The Dark Knight Returns!!!              Let's Go Penguins!!!
===============================================================================

Lance Andersen wrote:

> Let me dig up the exact CR numbers and I will post them back here
> tommorrow.

	Hey, great! I'll look out for them. Thanks.

-am