DB2 version upgrade

[gaya3]

Hi,

There is going to be a DB2 database upgrade to 9.5 in our projects. I need to know if there would be any compatibility problems with the DB2 plugin. Currently we are using DB2 versions 8.2 and 9.1 and the jobs are running fine.

Thanks,
Gaya3

[gaya3]

Hi everyone,

I am waiting for your answers! Can you please tell me if there would be any compatibility issues?

Thanks,
Gaya3

[cppwiz]

We recently upgraded from DB2 9.1 to 9.5 and had a major issue that prevented DataStage from running any jobs. Here's the solution:

Environments
Affected:
Datastage 7.5.x and 8.x using DB2 EE Stage to connect to remote
DB2 databases with following
levels:

DB2 V8 FP16 (and
higher)

DB2 V9.1 FP5 (and higher);


DB2 V9.5 FP2 (and
higher)

DB2 with APAR
IZ04271.

A changed introduced in DB2 (APAR IZ04271) on the timing for initializing
environment variables is found to be the cause of this
issue. As a result of this change, once the DB2INSTANCE value is
loaded and cached in memory, it cannot be reset by setenv. This affects
the way that Datastage establishes the DB2 environment for the
remote connectivity.

Solution:

Use Datastage startup.apt script to set up the DB2
environment.
Procedures:

Datastage Parallel Extender (PX) provides the ability to run a
startup script on every PX node. This script should be placed into the
PX installation as $APT_ORCHHOME/etc/startup.apt . If there is a
shared disk for all PX nodes, this default location could be replaced by
using the environmental variable
APT_STARTUP_SCRIPT.
The following sample script can be used to set up the DB2
environment:
#startup.apt

#!/bin/sh

if [ `hostname` != "ETLhostname" ̈]; then

unset
DB2INSTANCE
fi

shift 2

exec
$*

[ray.wurlod]

Hi everyone,

I am waiting for your answers! Can you please tell me if there would be any compatibility issues?

Thanks,
Gaya3

A whole two hours had gone by. You really must learn patience if you are going to participate in an all-volunteer site like DSXchange.

If you need urgent answers, you will need to pay for them (which you can not do here). Sign up with your official support provider for premier service and learn just how much "urgent" can cost.

[gaya3]

Hi cpppwiz,

Thanks for the information. I think the option you have provided is for enterprise edition. But mine is a server edition. Any idea on whether the server edition 8.0.1 will go well with db2 9.5?

Thanks,
Gaya3