Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connectivity issue between datastage and unidata

Status
Not open for further replies.

roopeshvp

Programmer
Dec 25, 2012
1
US
Hi All,
I am new to datastage just managing to modify packages with my prior knowledge in ETL tools like DTS and SSIS.
Now have ran in to a connectivity issue between datastage and unidata DB.
Software environment-
Datastage 7.5.2 running on windows server accessing unidata 7 on HP UX machine.

I am able to connect to my unidata DB on the PROD HP UX server.
But when i change the connection to the TEST HP UX server the connection fails with the error
'ds_udtopen()unable to execute file select 30105 UDT error'
'ds.udtopen GCI $udtopen error 24'
The user ID i use to connect has access to Unidata in HP UX TEST box and i can connect to it from my unix emulator. But it fails from datastage.
Can you pleas tell what could the possible problem, are there any configuration of this user account that i need to do between datastage and unidata?

Thanks in advance!!
Roopesh
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top