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
Check if this post helps

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 :(

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

Code: Select all

. ./dsenv 
Now try

Code: Select all

bin/uvsh

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.