Anybody has experience restoring 9.5 database back to 9.1 ?

Our environment is WIN 2003 64 bit. Thank you in advance.
By the way, any doubt I had running enterprise DB2 applications on
Windows vs Unix has been erased. DB2 on Win is just as potent as it is
on Unix.

On 1/6/2011 11:39 AM, Richard wrote:

To the best of my knowledge you cannot back out a version upgrade of a
database (that's why it is strongly recommended to do a backup before
upgrading)
Fixpacks by contrast can be backed out as long as you have not used any
new function.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau

On Jan 6, 2:36*pm, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:
Catalog table structure has been changed. No way to fall back to v9.1

The only way is rebuild the database. Export all the data from the
v9.5 database, create v9.1 database and import all the data. You need
to work with db2look and db2move.

Thanks
Arthur

On Thursday, January 6, 2011 5:39:00 PM UTC+1, RSL wrote:
Potent in what regard? We have a few productive DB2 installations on Windows and my experience was not so good... Mostly because the tools we have forUnix don't work under Windows. If you're better at administrating Windows than Unix, you may be better off with Windows. I personally can't wait thatwe begin using Linux to achieve the price/performance of x86 and the maintainability of Unix.

Rebuild db is messy because of constraints, triggers, packages...etc.
Its not as simple as reimport the data.

Will this work ? I restore the 9.1 db with the very last online
backup, then rollforward all the logs including those
started in db2 9.5 ? That way I got my old 9.1 database back + new
data off the 9.5 logfiles. Is that do-able ?


Quick aside - my current Wintel 64 bit system is supporting hundreds
of stores nationwide running high volume OLTP without hiccup. It's
screamingly fast even as we ramp up in volume. I was a doubter before
thinking anything that big has to be a 'nix but surprise to find Win
2003 as stable and easy to managed as Linux. Sure I applied all the
dba & architure enhancements I know of but the performance so far
greatly exceeded my expectation.

Hi Richard,

On 01/06/2011 03:22 PM, Richard wrote:
No, you can't rollforward logs from a different version of DB2.
DB2 9.1 does not understand the format of DB2's 9.5 logs.

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

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

Thank you for your answers.
Looks like I have to reset management expectations.

One last thing, you CAN install multiple "copies" of db2 on same
server, right ?
eg, 9.1 and 9.5
and even different fixpak versions within ?

On Friday, January 7, 2011 3:21:24 PM UTC+1, RSL wrote:
Yes, that works quite well.

On 1/7/2011 9:21 AM, Richard wrote:
fixpack levels are fine.


--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau