We have a very old V7 instance running on Windows. The box that was
home to this instance crashed recently, and our systems folks want to
migrate everything off this old hardware. Once the provide the new
hardware, I'd like to install V9.7. I realize that I have to upgrade
to V8 prior to the upgrade, but I was trying to avoid installing V8 on
the new hardware. Should I be able to install V8 on my desktop, load
the V7 backup, backup the now-V8 database, and copy the backup to the
V9.7 box to restore? I'm struggling to find a download of V8 for
Windows on IBM's site. Any advice, and links to a V8 for Windows
backup? Thx.

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

I would use db2look (for DDL) and db2move (for data) to do the migration.

I you really want to do a backup and restore to V8, then you use a DB2 V8
fixpack, which has the entire DB2 code within the download (but with a
30-day license).

Thanks Mark.

Unfortunately, all I have is the V7 backup. When the system died, it
was decided to
build a new system. My thinking is that this is a good opportunity to
upgrade to V9.7.
I'd prefer to not install V7 on the new box, then upgrade to V8, then
upgrade to V9.7.
I'd rather do a clean V9.7, and then load a V8 backup after I've
loaded the V7 backup
into Express-C V8 on my desktop.

So, the fixpak has all the code. I always assumed it had deltas
only.

Should I be able to use Express-V V8 (lastest fixpak)? If yes, I'm
struggling to find it on IBM site.

Just found Express 8 FP 18.

D/L in now.

On an unrelated note. Why does google groups wrap lines at 80
characters? Text only displays on the
left 1/4 of my screen as a result. Is that a google groups setting
that I can change? Thanks.

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

It depends on the OS and DB2 release as to whether fixpacks have all the
code. The Windows versions have always had all the code. Some of the older
UNIX versions required install of base code before the fixpack, but that no
longer is true with newer DB2 versions.

IBM only posts the latest version of DB2 Express-C. But any of the ESE
versions (fixpacks) will install with a try and buy license (I believe it
will be good for 90 days). One you get the data into version 8, then I would
do a db2look and db2move to 9.7 with a clean 9.7 instance and database
install before you create the objects.

Thanks again.

Great idea with the db2look/db2move to keep the database clean. :-)

On 2010-10-21 20:15, Richard wrote:
A bit of warning though, earlier versions of db2look (I believe V8,
don't know if that improved) did not respect the order in which the
objects should be created, so some objects referenced other object not
yet created. To overcome this limitation I had to creata a small parser
that read dependencies from the catalog, and sorted the db2look output
accordingly.


/Lennart