Search found 62 matches

by 2ksaint
Wed Mar 05, 2008 2:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: config db2 server and Datastage EE on IBM AIX
Replies: 18
Views: 5840

DB2DIR=/usr/opt/db2_08_01;export DB2DIR
DB2INSTANCE=db2inst1;export DB2INSTANCE

i dont know about db2clintpath, what path i have to set?
by 2ksaint
Tue Mar 04, 2008 5:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: config db2 server and Datastage EE on IBM AIX
Replies: 18
Views: 5840

thanks Arndw, I checked and found dsdb2.so file in /Datastage/DSEngine/lib I have configured the libpath in dsenv file as follows LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH export LIBPATH/bin:$LIBPATH:$INSTHOME/sql...
by 2ksaint
Tue Mar 04, 2008 2:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: config db2 server and Datastage EE on IBM AIX
Replies: 18
Views: 5840

i have configured db2 aswell as datastage. Now when i run the job im getting the following error "main_program: Fatal Error: Fatal: Shared library (dsdb2.so) failed to load: errno = (2), system message = (No such file or directory)
by 2ksaint
Mon Mar 03, 2008 11:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: seq stage to db2api stage
Replies: 3
Views: 1219

im also getting the same error, I configured everything.In which file I need to configure, pls im not clear on which file i have reconfigure
by 2ksaint
Mon Mar 03, 2008 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: config db2 server and Datastage EE on IBM AIX
Replies: 18
Views: 5840

config db2 server and Datastage EE on IBM AIX

I have db2 server,client, datastage EE installed on the same IBM AIX server. I have installed DS Client in windows xp pc. What are the configuration that i need to make in dsenv file and configure Environmental variable in order to make connectivity. Pls i need some example or detailed explanation w...
by 2ksaint
Wed Feb 27, 2008 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage, db2 remote connectivity
Replies: 12
Views: 4905

thanks chulett,

I will check and let you know. In the mean time im not able to connect to datastage server through datastage client (windows XP).

Im getting error "Failed to connect to host:"ip address" poject:UV (The connection was refused or the RPC dameon is not running(81016))
by 2ksaint
Wed Feb 27, 2008 5:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage, db2 remote connectivity
Replies: 12
Views: 4905

thanks chulett,

I will check and let you know. In the mean time im not able to connect to datastage server through datastage client (windows XP).

Im getting error "Failed to connect to host:"ip address" poject:UV (The connection was refused or the RPC dameon is not running(81016))
by 2ksaint
Tue Feb 26, 2008 11:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage, db2 remote connectivity
Replies: 12
Views: 4905

thanks chulett, But i havent installed db2 client in aix machine, i have it on windows machine. Since i have it on windows machine, will i be not able to view the database in the server? Since db2 client is installed on windows machine, i will be having db2 driver, so using that, i will not be able ...
by 2ksaint
Tue Feb 26, 2008 10:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage, db2 remote connectivity
Replies: 12
Views: 4905

ray i would like to explain in more specific. DS server and db2 enterprise installed on the same unix server which is located at one place. Ds client and db2 client installed in same pc which has windows xp. Now I need to create dsn through odbc in order to take db2. Usually we do by going to contl ...
by 2ksaint
Tue Feb 26, 2008 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage, db2 remote connectivity
Replies: 12
Views: 4905

datastage, db2 remote connectivity

hi, I have ds server and db2 in unix server and i have ds client in windows xp. 1. Do i need to configure db2 files or ds files like dsenv,db2profile,default.apt 2. How to create dsn what we do in windows for connecting db2 using odbc in unix. 3. What are all the Environmental variables that i need ...
by 2ksaint
Tue Feb 26, 2008 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing SAS Package
Replies: 11
Views: 2189

thanks ray & Istsaur,

sorry for the delayed response. I will do this, once i succeed i will let you know guy.

Thanks for your all prompt response...

:)
by 2ksaint
Fri Feb 22, 2008 5:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing SAS Package
Replies: 11
Views: 2189

thanks Istsaur, we found that SAS software is installed on the AIX server and while installing the Datastage Server we, skipped the third propmt which will ask for SAS code as at the time of installation we thought that we dont need the SAS code. Now we need to have the SAS component. So is there an...
by 2ksaint
Thu Feb 21, 2008 1:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing SAS Package
Replies: 11
Views: 2189

thanks ray.

If I have SAS Authentication Code, is there any way, where i can just update the SAS code (Update Licence) so that I can work with SAS stage.
by 2ksaint
Thu Feb 21, 2008 1:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing SAS Package
Replies: 11
Views: 2189

i had install ds 7.1.a in Aix box with db2 in it and while installing I didnt gave the sas auth code. now i need to install sas. So from your point, I have to reinstall the ds after taking the backup and then enter the SAS auth code to work with SAS. If we install DS we are able to find SAS componen...
by 2ksaint
Fri Feb 15, 2008 3:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to configure the DB2 Plug In in UNIX for server
Replies: 4
Views: 3402

regarding the same request as vijaydev

Hi vijaydev, Im also configuring the same like installing ds v7.5.1a in AIX and configuring Db2 v8.2 to work with Ds. I had read all the articles and the Ds install and upgrade guide.. If you had done the config, please tell me how to configure odbc in order to create DSN like for Db2 in AIX.. Which...