HPUX-Datastage | Unix Linux Forums | HP-UX

  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

Closed Thread    
Thread Tools Search this Thread Display Modes
Old 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 12-27-2012
DGPickett DGPickett is offline Forum Advisor  
Registered User
Join Date: Oct 2010
Last Activity: 17 February 2015, 1:56 PM EST
Location: Southern NJ, USA (Nord)
Posts: 4,671
Thanks: 8
Thanked 584 Times in 557 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
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 01:21 PM
pwage-hpux-T for Trusted HPUX servers sparcguy HP-UX 2 03-24-2011 11:07 PM
Datastage TX sonja UNIX and Linux Applications 1 07-09-2010 05: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 08:20 AM
can we use routines of datastage in unix script nimmyraju Shell Programming and Scripting 0 11-10-2008 02:50 AM

All times are GMT -4. The time now is 08:58 PM.