Hi And Welcome Aboard ,
DS is still 32Bit application (except Itanium processors on HP which has 64Bit version), therefor in order to have it interact with 64Bit DB you need a 32Bit client to connect to your DB.
Usually there is a version for 32Bit or one that supports both 64Bit and 32Bit applications.
You'll have to check if one exists for your configuration.
You might want to check future releases of 64Bit DS application availability options with your support.
IHTH,
DataStage 7.5.1 vs. DB2 UDB 8.2 in 64bit-mode
Moderators: chulett, rschirm, roy
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Our issue goes a little deeper...
Our situation:
- Upgrading to a 64-bit DB2 database and 64-bit DB2 client (but the directories for 32-bit are also installed)
- AIX 5.2 operating system
- Datastage PX 7.5
We have datastage jobs that:
- read and write to DB2 tables
- call unix scripts that use DB2 CLI command line statements (eg. "db2 connect to zzz").
The problem:
- We can get Datastage working with DB2 by changing the LIBPATH to point to the 32-bit library. We also change the PATH to use the 32-bit bin. However, the "db2 connect to" statement times out before it connects.
It seems like we cannot have a situation that allows us to use Datastage AND use the CLI.
Options we're considering:
- Write a "wrapper" for the unix scripts called by Datastage, to change the PATH and LIBPATH to point to the 64-bit DB2 directories. It's more of a kludge than an elegant solution. It also worries me that by "tricking" the system to use 32-bit, things may fall in a heap if there are any unexpected 64-bit function calls.
- Install another DB2 instance that is 32-bit (to be used by Datastage), and remotely use the 64-bit instance, which requires some fiddling with the unix scripts and database binding, and complicates the configuration.
Has anyone got a solution to this issue, or can they suggest other options?
Our situation:
- Upgrading to a 64-bit DB2 database and 64-bit DB2 client (but the directories for 32-bit are also installed)
- AIX 5.2 operating system
- Datastage PX 7.5
We have datastage jobs that:
- read and write to DB2 tables
- call unix scripts that use DB2 CLI command line statements (eg. "db2 connect to zzz").
The problem:
- We can get Datastage working with DB2 by changing the LIBPATH to point to the 32-bit library. We also change the PATH to use the 32-bit bin. However, the "db2 connect to" statement times out before it connects.
It seems like we cannot have a situation that allows us to use Datastage AND use the CLI.
Options we're considering:
- Write a "wrapper" for the unix scripts called by Datastage, to change the PATH and LIBPATH to point to the 64-bit DB2 directories. It's more of a kludge than an elegant solution. It also worries me that by "tricking" the system to use 32-bit, things may fall in a heap if there are any unexpected 64-bit function calls.
- Install another DB2 instance that is 32-bit (to be used by Datastage), and remotely use the 64-bit instance, which requires some fiddling with the unix scripts and database binding, and complicates the configuration.
Has anyone got a solution to this issue, or can they suggest other options?
The DB2 guys suggested:
- Installing a 32-bit DB2 instance, and remotely use the 64-bit instance.
We didn't really want to do that, so for now we've gone with the "kludge" in the called unix script that changes the LIBPATH and PATH to point to the 64-bit directories, just prior to running the "db2" command.
- Installing a 32-bit DB2 instance, and remotely use the 64-bit instance.
We didn't really want to do that, so for now we've gone with the "kludge" in the called unix script that changes the LIBPATH and PATH to point to the 64-bit directories, just prior to running the "db2" command.
db2 connection error when pre-job subroutine script
Hi i'm getting the similar kind of error , when connecting to DB2 64-bit instance.Gazelle wrote:The DB2 guys suggested:
- Installing a 32-bit DB2 instance, and remotely use the 64-bit instance.
We didn't really want to do that, so for now we've gone with the "kludge" in the called unix script that changes the LIBPATH and PATH to point to the 64-bit directories, just prior to running the "db2" command.
Currently the LD_LIBRARY_PATH has this value which points to 64 bit lib.
/IBMdb2/home/db2rtcl/sqllib/lib64:/opt/IBMdb2/V8.1/lib64
But should the PATH variable also needs a change ? And if could you specify them also ?
Thanks !