Incompatibility between DataStage and IBM DB2 64 bit
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
Incompatibility between DataStage and IBM DB2 64 bit
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?
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?
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.
You do this by ensuring the proper libraries are listed first in the appropriate 'library path' environment variable for your platform.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
How is that possible? We should connect through a 64 bit client to 64 bit server. That makes more sense right?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.......
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am