Migrating packages from a V9 to a V8 database

Frances Warren

Migrating packages from a V9 to a V8 database
We are trying to plan an upgrade from V8 to V9 with lots of dependencies
including application upgrades. One of our tentative plans involves writing
and testing code under V9, but deploying it in production which would still be
version 8. We could test it in another V8 system before deployment, but is
migration of a package from a V9 database to a V8 database possible?
Any comments, tips or ideas?

_____________________________________________________________________

* 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

Roger Miller

Re: Migrating packages from a V9 to a V8 database
(in response to Frances Warren)
The tricky part would be to make sure that the application which you code
and test on DB2 9 does not contain anything that is not part of V8. For the
application code itself, there are some reasonable options where you are
using a precompiler or coprocessor. Only allow the precompiler for V8 or
set the NEWFUN value to V8 (new APAR, value NO currently). Where the
SQL is dynamic, the challenge is greater. The migration package might
include some new DDL that works fine on 9, provides an error on V8, for
example. You'd need to be particularly careful where access to catalog data
is used, or any other situation where the application has some awareness of
the version it runs on. Test on the version you run on is safer.

Roger Miller, DB2 for z/OS

On Tue, 15 Dec 2009 01:30:11 +0000, Frances Warren
<[login to unmask email]> wrote:

>We are trying to plan an upgrade from V8 to V9 with lots of dependencies
>including application upgrades. One of our tentative plans involves writing
>and testing code under V9, but deploying it in production which would still
be
>version 8. We could test it in another V8 system before deployment, but is
>migration of a package from a V9 database to a V8 database possible?
>Any comments, tips or ideas?
>
>_________________________________________________________
____________

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

_____________________________________________________________________

* 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