Projects are not visible through dsjob -lprojects
Moderators: chulett, rschirm, roy
Projects are not visible through dsjob -lprojects
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.
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
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.
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
if you do the commands:
what is the screen output? Is your dssdev project displayed?
Code: Select all
cd $DSHOME
./bin/dssh
LIST UV.ACCOUNT
QUIT
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Thanks for your response.ArndW wrote:if you do the commands:what is the screen output? Is your dssdev project displayed? ...Code: Select all
cd $DSHOME ./bin/dssh LIST UV.ACCOUNT QUIT
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
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Yes, I did that earlier and again I tried that just before executing ./bin/dssh. But got same error message.ArndW wrote:Run ". ./dsenv" after the "cd $DSHOME", since this is the prerequisite for all DataStage shell commands.
"
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
is wrong, execute ". ./dsenv" the leading ". " is very important.swarnkar wrote:bash-3.00$ ./dsenv
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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"
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"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ok, the next step:
This is to see if the VOC file of that project contains data.
Code: Select all
cd $DSHOME
. ./dsenv
bin/dshh
LOGTO dssdev
COUNT VOC
QUIT
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I have executed the command.
Please see the results below.
Thanks & Regards,
Nitin Swarnkar
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
Nitin Swarnkar
I have executed the command.
Please see the results below.
Thanks & Regards,
Nitin Swarnkar
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
Nitin Swarnkar
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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Please see the result below
Thanks & Regards,
Nitin Swarnkar
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
Please see the result below
Thanks & Regards,
Nitin Swarnkar
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