Incompatibility between DataStage and IBM DB2 64 bit

abhilashnair · Post by **abhilashnair** » Mon May 14, 2007 8:21 am

Recently, I worked on a project in my organization, in which we removed all such before job and after job scripts from DS jobs(server as well as PX), which were loading a DB2 table.

The reason for this we were told that we were going in for a DB2 upgrade from 32 bit to 64 bit. So if there is a before job script or after job which loads data into the DB2 table, the DS job will fail.

The root cause was not conveyed to us.

May I know any specific reason for this?

chulett · Post by **chulett** » Mon May 14, 2007 8:26 am

DataStage is a 32bit application on most platforms. I doubt you'll find they are truly incompatible, but instead you must use the 32bit libraries to access it rather than the 64bit ones.

You do this by ensuring the proper libraries are listed first in the appropriate 'library path' environment variable for your platform.

csrazdan · Post by **csrazdan** » Mon May 14, 2007 8:34 am

Since DataStage is 32-bit application you will have to install 32-bit DB2 client to connect to 64-bit DB2 database.

In Oracle also you use lib32 libraries to connect to Oracle database from DataStage.

Hope it helps.......

ray.wurlod · Post by **ray.wurlod** » Mon May 14, 2007 4:41 pm

...and make very sure that $APT_ORCHHOME/lib appears in the shared library search path ahead of ANY database client library.

abhilashnair · Post by **abhilashnair** » Tue May 15, 2007 12:07 am

But why is it that only before and after job script fails. If the DB2 table is accessed by a DS job, it does not fail? I am not able to understand this.

Btw, the script used is a Korn Shell Script and the DataStage server is on Unix. We connect through Windows

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 12:59 am

If a before-job subroutine fails, nothing else in the job happens.

abhilashnair · Post by **abhilashnair** » Tue May 15, 2007 5:49 am

csrazdan wrote:Since DataStage is 32-bit application you will have to install 32-bit DB2 client to connect to 64-bit DB2 database.

In Oracle also you use lib32 libraries to connect to Oracle database from DataStage.

Hope it helps.......

How is that possible? We should connect through a 64 bit client to 64 bit server. That makes more sense right?

chulett · Post by **chulett** » Tue May 15, 2007 7:43 am

Not when you are talking about a 32bit application.

abhilashnair · Post by **abhilashnair** » Mon Jun 11, 2007 4:13 am

Need some more insight into this whole thing. I am still not clear. Can anyone provide any link or something which has information on this?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 11, 2007 5:21 am

The 32-bit DB2 library is required because DataStage IS a 32-bit client. The 32-bit DB2 library is entirely capable of communicating with a 64-bit DB2 instance.

chulett · Post by **chulett** » Mon Jun 11, 2007 6:33 am

If you still aren't clear on this by now from the various threads on the topic here, I'd suggest you call your official Support provider. Have them see if they can explain it to you and help you set it up.

abhilashnair · Post by **abhilashnair** » Wed Jun 13, 2007 12:49 am

ray.wurlod wrote:The 32-bit DB2 library is required because DataStage IS a 32-bit client. The 32-bit DB2 library is entirely capable of communicating with a 64-bit DB2 instance. ...

In that case the job should not fail while trying to load a table.
Then why it is failing?