Upgrading db2 from 9.5 to 9.7

Harold Pritchett

Upgrading db2 from 9.5 to 9.7
I am running db2exc. Currently at 9.5.0, I am looking at
putting up a test server at the 9.7.0.1 level. The
existing server is 32 bit db2 running under Red Hat Enterprise Linux
5.4 32 bit. The new test server is 64 bit db2 running under Red Hat
Enterprise Linux 5.4 64 bit.

I want to take a standalone backup from my old system and
restore it to my test system.

The backup was taken with:

BACKUP DATABASE ANIMALS
USER db2inst9
using xxxxxxxx
TO '/db2home/backup1'
WITH 1 BUFFERS
BUFFER 0
PARALLELISM 1
WITHOUT PROMPTING;

My current restore script contains:

RESTORE DATABASE ANIMALS
USER db2inst9
using xxxxxxxx
FROM '/db2home/restore1'
REPLACE EXISTING
WITHOUT ROLLING FORWARD
WITHOUT PROMPTING;

Should this work?

Is there anything I need to do because the backup is taken
on a 32 bit system and restored on a 64 bit system?

Harold

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Jeffrey Garmon

Re: Upgrading db2 from 9.5 to 9.7
(in response to Harold Pritchett)
Based on the 9.5 admin guide, I believe what you're proposing will work:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?
topic=/com.ibm.db2.luw.admin.ha.doc/doc/c0005960.html

To quote the manual:

"The target system must have the same (or later) version of the DB2
database product as the source system. You cannot restore a backup
created on one version of the database product to a system running an
earlier version of the database product. For example, you can restore a DB2
UDB V8 backup on a DB2 V9 database system, but you cannot restore a
DB2 V9 backup on a DB2 UDB V8 database system.

Note: You can restore a database from a backup image taken on a 32–bit
level into a 64–bit level, but not vice versa."

Jeff

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L