We're in the planning stages for a DB2 upgrade from 8.2 & 9.1 to 9.7
FP3a. I've never applied a fix pack or upgraded an instance to a
newer version. We're planning an in-place upgrade. My question is
this, can we load the 9.7 software, then load the 3a fix pack, before
migrating the instance and databases, OR, do we load the 9.7 software,
migrate the instance and databases, then apply FP3a?

Thanks.

On 24 nov, 16:26, Richard <rmcgor... (AT) gmail (DOT) com> wrote:
Since the server fixpack is a fully functional version of DB2, there
is no need to install the base version and upgrade afterwards.

--
Frederik

If you still have type-1 indexes, you should migrate them to type-2 indexes
before the upgrade. In 9.7 type-1 indexes are no longer supported, which means
that all type-1 indexes will be marked invalid and have to be rebuild when
accessed for the first time.

Also check the bit support first. Since 9.1, you can't have an instance
running with a different bit width than the OS bit width.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/