Page 1 of 2
Unable to connect to DataStage using Universe Shell
Posted: Tue Dec 26, 2006 10:44 am
by raki
Hi DataStage gurus,
I'm unable to connect to DataStage using Univers Shell. I am getting the following errors:
$ bin/uvsh
DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
DSEngine logged on: Tuesday, December 26, 2006 11:41
DataStage/SQL: Failed to establish internal local connection.
Can somebody please help me fix this. Is there an environment variable i have to set?
Posted: Tue Dec 26, 2006 10:47 am
by kcbland
Welcome to the forum! Did you do a ". ./dsenv" prior to starting the shell? If so, then is this a new installation of DataStage?
Posted: Tue Dec 26, 2006 11:16 am
by raki
thanks for the quick reply,
I did a cd $DSHOME (/ascential/Ascential/DataStage/DSEngine) from here i ran Universe using bin/uvsh
Posted: Tue Dec 26, 2006 11:21 am
by narasimha
So.. are you saying you resolved your issue. If yes, mark the post as resolved.
Else get back, if you need more information.
Posted: Tue Dec 26, 2006 11:26 am
by raki
we upgraded from server edition to parallel edition
Posted: Tue Dec 26, 2006 11:27 am
by raki
No its still not working.
Posted: Tue Dec 26, 2006 11:29 am
by narasimha
Posted: Tue Dec 26, 2006 12:47 pm
by raki
i think that post might have the answer, but i
Posted: Tue Dec 26, 2006 12:54 pm
by raki
sorry what i meant to say was that that post might have the anwer but i'm unable to view the post properly as i am not a premium member.
Posted: Tue Dec 26, 2006 12:56 pm
by narasimha
raki wrote:i think that post might have the answer, but i
Please be complete and clear in your answers.
Also for further usage, there is a functionality to go back and edit your posts. You could make use of it.
You will miss on a lot of premium information if you are not a premium member
![Sad :(](./images/smilies/icon_sad.gif)
Posted: Tue Dec 26, 2006 1:06 pm
by ds1user1
In the post check the 4,5 and 6 entries. JP had the same problem and resolved that by changing the uvodbc.config files information. i,e; Loacl host connection.
Happy Holidays.
Posted: Tue Dec 26, 2006 3:06 pm
by raki
i have checked the uvodbc.config file. host is set as
host = 127.0.0.1
when i run Universe from command prompt, do i have to be in the project directory?
when i did that i'm getting a different error.
$MYNAME$ $DSHOME/bin/uvsh
ld.so.1: uvsh: fatal: libdsplugin.so: open failed: No such file or directory
Killed
Please advice. Thank you.
Posted: Tue Dec 26, 2006 3:12 pm
by narasimha
Did you source dsenv first.
You need to go to your dshome and type this
Now try
Posted: Tue Dec 26, 2006 3:27 pm
by raki
i tried that too. still same error.
$MYNAME$ $DSHOME/bin/uvsh
ld.so.1: uvsh: fatal: libdsplugin.so: open failed: No such file or directory
Killed
Posted: Tue Dec 26, 2006 3:32 pm
by narasimha
Check
this.
You could do a search yourself too. Search feature is pretty good
here.