In the 9.7 Upgrade roadmap it says:

Upgrading a primary database to DB2 Version 9.7 changes the database
role from primary to standard. Upgrading standby databases to DB2
Version 9.7 is not supported because these databases are in roll
forward pending state. Because of these restrictions, upgrading an
HADR environment to DB2 Version 9.7 requires that you stop HADR,
upgrade your DB2 server where the primary database resides, and then
re-initialize HADR.

The following list includes each of these actions and the topic where
is documented:
- Stop the HADR primary or standby databases as in indicated in
the Pre-upgrade tasks for DB2 servers.
- Upgrade the DB2 server where the primary database resides
- Re-initialize HADR


There's no mention of installing 9.7 on the Standby. That doesn't
make sense to me. It seems like you should install 9.7 on the
Standby, drop you standby db, upgrade the instance to 9.7, then re-
establish HADR.

What am I missing?

Thanks.

On 27 jan, 17:04, Richard <rmcgor... (AT) gmail (DOT) com> wrote:
I don't think you're missing anything. What you understood is exactly
what it says. Re-initialize HADR is a big step...

--
Frederik Engelen

There is no rolling upgrade for different DB2 releases (e.g. 9.5 -> 9.7).
In this case you have to recreate the standby database again.

But when applying fixpaks, you can do that more or less online.

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

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

"Richard" <rmcgorman (AT) gmail (DOT) com> wrote

You must install 9.7 and upgrade the instances on both primary and standby.