Unable to connect to DataStage using Universe Shell

raki · Post by **raki** » Tue Dec 26, 2006 10:44 am

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?

kcbland · Post by **kcbland** » Tue Dec 26, 2006 10:47 am

Welcome to the forum! Did you do a ". ./dsenv" prior to starting the shell? If so, then is this a new installation of DataStage?

raki · Post by **raki** » Tue Dec 26, 2006 11:16 am

thanks for the quick reply,

I did a cd $DSHOME (/ascential/Ascential/DataStage/DSEngine) from here i ran Universe using bin/uvsh

narasimha · Post by **narasimha** » Tue Dec 26, 2006 11:21 am

So.. are you saying you resolved your issue. If yes, mark the post as resolved.
Else get back, if you need more information.

raki · Post by **raki** » Tue Dec 26, 2006 11:26 am

we upgraded from server edition to parallel edition

raki · Post by **raki** » Tue Dec 26, 2006 11:27 am

No its still not working.

narasimha · Post by **narasimha** » Tue Dec 26, 2006 11:29 am

Check if this post helps

raki · Post by **raki** » Tue Dec 26, 2006 12:47 pm

i think that post might have the answer, but i

raki · Post by **raki** » Tue Dec 26, 2006 12:54 pm

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.

narasimha · Post by **narasimha** » Tue Dec 26, 2006 12:56 pm

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

ds1user1 · Post by **ds1user1** » Tue Dec 26, 2006 1:06 pm

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.

raki · Post by **raki** » Tue Dec 26, 2006 3:06 pm

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.

narasimha · Post by **narasimha** » Tue Dec 26, 2006 3:12 pm

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

raki · Post by **raki** » Tue Dec 26, 2006 3:27 pm

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

narasimha · Post by **narasimha** » Tue Dec 26, 2006 3:32 pm

Check this.

You could do a search yourself too. Search feature is pretty good here.