Unix/Linux Go Back    

HP-UX HP-UX (Hewlett Packard UniX) is Hewlett-Packard's proprietary implementation of the Unix operating system, based on System V.



datastage, unidata

Thread Tools Search this Thread Display Modes
Old Unix and Linux 12-27-2012
roopeshvp roopeshvp is offline
Registered User
Join Date: Aug 2011
Last Activity: 27 December 2012, 5:46 AM EST
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

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!!
Sponsored Links
Old Unix and Linux 12-27-2012
DGPickett DGPickett is offline Forum Advisor  
Registered User
Join Date: Oct 2010
Last Activity: 1 February 2016, 3:35 PM EST
Location: Southern NJ, USA (Nord)
Posts: 4,673
Thanks: 8
Thanked 587 Times in 560 Posts
Is this a password authentication situation? If else fails on any UNIX app, I fall back on truss/tusc/strace, in your case on the unidata db login process, if you have the access there. Then you can see all the dialog and resources during the login.

Some apps will not log you in if your IP reverse does not look up, which can vary on different servers.
Sponsored Links

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Datastage Installation Problem amarn48 UNIX for Advanced & Expert Users 4 11-22-2011 12:21 PM
pwage-hpux-T for Trusted HPUX servers sparcguy HP-UX 2 03-24-2011 10:07 PM
Datastage TX sonja UNIX and Linux Applications 1 07-09-2010 04:16 AM
Need Script to Use CPUs on a HPUX server to simulate Workload Manager on HPUX. cpolikowsky Shell Programming and Scripting 2 02-18-2009 07:20 AM
can we use routines of datastage in unix script nimmyraju Shell Programming and Scripting 0 11-10-2008 01:50 AM

All times are GMT -4. The time now is 01:42 PM.