Projects are not visible through dsjob -lprojects

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Projects are not visible through dsjob -lprojects

Post by swarnkar »

Hi,

We have Datastage Installed on SUN Solaris 5.1.
Same Unix box is used for multiple applications like peoplesoft, Datastage
development, Quality environment and Database of Development and QA are also there in same box.

In director log of any job of my project, Name of the project looks as "dssdev (etl-dev:32335) "

Where "dssdev" : is the DataStage Project Name.

etl-dev is the host name of the Unix box.
32335 is the port name, associated with server.


Now when I log into $DSHOME/bin and execute "dsjob -lprojects"

I could not find my project, i.e. "dssdev"

But when I log to "Projects" directory, there is can see the directory of my project.

According to me, its is because of the host name of the UNIX server as there is port name associated with it.

But I don't know, How to telnet a server with host name. :cry:

The task in my hand, is to send error messages (if at all) with the mail,
where job is executed through Control-M Schedular.

So I am trying to execute "dsjob -logsum" command, but I am getting an error message stating "Project not found"

Please help me to resolve this issue.

Thanks.

Regards,
Nitin Swarnkar
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

if you do the commands:

Code: Select all

cd $DSHOME
./bin/dssh
LIST UV.ACCOUNT
QUIT
what is the screen output? Is your dssdev project displayed?
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

ArndW wrote:if you do the commands:

Code: Select all

cd $DSHOME
./bin/dssh
LIST UV.ACCOUNT
QUIT
what is the screen output? Is your dssdev project displayed? ...
Thanks for your response.

When I run " ./bin/dssh". I got following error message.

"ld.so.1: uvsh: fatal: libdsplugin.so: open failed: No such file or directory
Killed"

But when I list the "bin" directory for "dssh". The output of that command is

"
bash-3.00$ ls -l dssh
lrwxrwxrwx 1 uatbwetl bcw 4 Feb 7 2009 dssh -> uvsh

"

And I have loged into the system as "uatbwetl" user. Who is the owner of the file.

Regards,
Nitin Swarnkar
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

The assumption was that you had already run ". ./dsenv" after the "cd $DSHOME", since this is the prerequisite for all DataStage shell commands. Please do so and re-run the commands.
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

ArndW wrote:Run ". ./dsenv" after the "cd $DSHOME", since this is the prerequisite for all DataStage shell commands.
Yes, I did that earlier and again I tried that just before executing ./bin/dssh. But got same error message.

"
bash-3.00$ ./dsenv
bash-3.00$ ./bin/dssh
ld.so.1: uvsh: fatal: libdsplugin.so: open failed: No such file or directory
Killed
"

Regards,
Nitin Swarnkar
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

swarnkar wrote:bash-3.00$ ./dsenv
is wrong, execute ". ./dsenv" the leading ". " is very important.
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

ArndW wrote:execute ". ./dsenv" the leading ". " is very important. ...
Thanks ArndW.

Now .bin/dssh is working.

When I executed LIST UV.ACCOUNT

I could see my project "dssdev" there.

Regards,
Nitin Swarnkar
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

The Output of LIST UV.ACCOUNT, Looks like.

LIST UV.ACCOUNT 12:08:04pm 31 Mar 2010 PAGE 1
Account... UID GID Owner name...... UNIX pathname........... Permissions

uv /usr/appl/bcw/etl/Ascent
ial/DataStage/DSEngine
UV /usr/appl/bcw/etl/Ascent
ial/DataStage/DSEngine
ds /usr/appl/bcw/etl/Ascent
ial/DataStage/DSEngine
DS /usr/appl/bcw/etl/Ascent
ial/DataStage/DSEngine
dssdev DataStage\7.5\ep /usr/appl/bcw/etl/Ascent
m-uat:31539\3757 ial/DataStage/Projects/d
3 ssdev
dssqa DataStage\7.5\ep /usr/appl/bcw/etl/Ascent
m-uat:31539\5798 ial/DataStage/Projects/d
1 ssqa


But none of these projects are there in the output of "dsjob -lprojetcs"
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Please wrap the listing in Code tags so that it makes sense.

The uv, UV, ds and DS "projects" are always omitted from the list of projects, because they are not actually projects.

It appears, from the trashed report you've provided, that project names dssqa and dssdev should appear.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Ok, the next step:

Code: Select all

cd $DSHOME
. ./dsenv
bin/dshh
LOGTO dssdev
COUNT VOC
QUIT
This is to see if the VOC file of that project contains data.
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

I have executed the command.

Please see the results below.

Code: Select all

bash-3.00$ bin/dssh
DataStage Command Language 7.5
Copyright (c) 1997 - 2003 Ascential Software Corporation. All Rights Reserved
DSEngine logged on: Thu Apr  1 09:24:53 2010

>LOGTO dssdev
>COUNT VOC

10385 records counted.
>QUIT
Thanks & Regards,
Nitin Swarnkar
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

I have executed the command.

Please see the results below.

Code: Select all

bash-3.00$ bin/dssh
DataStage Command Language 7.5
Copyright (c) 1997 - 2003 Ascential Software Corporation. All Rights Reserved
DSEngine logged on: Thu Apr  1 09:24:53 2010

>LOGTO dssdev
>COUNT VOC

10385 records counted.
>QUIT
Thanks & Regards,
Nitin Swarnkar
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Ok, that number corresponds to a well-filled project. Perhaps the UV_SCHEMA entry is corrupted:

Code: Select all

{procedure as before to get into the UVSH}
LIST UV_SCHEMA
QUIT
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

Please see the result below

Code: Select all

LIST UV_SCHEMA 09:46:56am  01 Apr 2010  PAGE    1

Schema. CATALOG
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/DSEngine/sql/catalog

Schema. BCWinstall
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/BCWinstall

Schema. dssSYS
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssSYS

Schema. dssdev
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssdev

Schema. dssqa
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssqa

Schema. dsstest

LIST UV_SCHEMA 09:48:02am  01 Apr 2010  PAGE    2

Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dsstest

Schema. dssFIRECALL
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssFIRECALL


7 records listed.
QUIT


Thanks & Regards,
Nitin Swarnkar
Top
swarnkar
Participant
Posts: 74
Joined: Wed Jan 11, 2006 2:22 am

Post by swarnkar »

Please see the result below

Code: Select all

LIST UV_SCHEMA 09:46:56am  01 Apr 2010  PAGE    1

Schema. CATALOG
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/DSEngine/sql/catalog

Schema. BCWinstall
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/BCWinstall

Schema. dssSYS
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssSYS

Schema. dssdev
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssdev

Schema. dssqa
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssqa

Schema. dsstest

LIST UV_SCHEMA 09:48:02am  01 Apr 2010  PAGE    2

Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dsstest

Schema. dssFIRECALL
Owner.. 19758
Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/dssFIRECALL


7 records listed.
QUIT


Thanks & Regards,
Nitin Swarnkar
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”