DSXchange

just a note...the user was given full permissions to the sqllib folder on the DS server and also added to the DB2ADMNS group on the server as well.

Hi, We have a new user who is getting the following error when doing a view data on a ODBC stage.... GE_Data_Call..odbcgeCall: DSD.BSIConnect connecting to $PROJDEF, call to SQLConnect failed. SQLSTATE=IM002,DBMS.CODE=0 [DataStage][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Data source name n...

I remember editing the file in notepad but then having to run the "regen" command in DOS so the changes can take affect

Thanks Ray...Is there a "DOS" equivalend? I remember I did everything in the DOS command without invoking shell.

Hi, Way back IBM had me update our UVCONFIG file on our server. My local machine has crashed and have lost the email with their directions as to how to accomplish this. I searched and found direction for UNIX/AIX but we are running on Windows 2003. I remember some pieces I think. Modify the uvconfig...

Thanks chulett!! After getting through the red tape of getting Admin rights to the box and a copy of the software, it worked just like you stated.

Hi, We recently promoted some jobs from our QA environment to PROD and it is failing with: jbCleanup_Fund_Perfmnc..srtAssetIdSort: No suitable "DSActiveStageC" object of type "sort" found. The sort stage is not on the pallete either. I tried exporting(from QA) and importing IT in...

After the patch and including the domain parameter in our execution we are now getting: dsJob.exe FAILED with error code: -2 This error only shows up on the remote server executing the DSJOB command. No history or traces of the job ever being kicked off on the DataStage server. Support is now passin...

Yes, they wanted us to include the domain parameter since we are executing from a remote server

Just received this from IBM suport....we will be running another volume test on Monday and I will report in to let everyone know if this resolves our issue. I know dsjob changed for Version 8 to require the domain name. type dsjob801.txt Needs to use the format: dsjob -domain domainserver:9080 -user...

Sorry for not mentioning, but yes he mentioned that's what they opened at his shop for version 8.1 Enetrprise edition.

Sorry for not mentioning, but yes he mentioned that's what they opened at his shop for version 8.1 Enetrprise edition.

A friend just emailed me this list of Ports...he wasn't sure where he got them from.....

Ports : 5558,5578 ,7276 ,7286,8880,9043 ,9060 ,9100 ,9353 ,9401,9402,9403,
9443 ,9809 ,31531 ,31533 ,50000 ,2809 ,9080 ,31538 ,23

We haven't changed the default port so we may just try opening 31538. We are in the processing of migrating all our projects to the enetrprise edition 8.0.1 so I'll keep this opened for the 8.o ports as well.

Thanks!! :D

Hi,
we have outsourced much of our development work to a firm in India and was wondering if there is a laundry list of ports that need to be opened in order for them to connect to our server. If not, is there a way for me to determine the ports?
Thanks - - John