dsjob call from PC to AIX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Wed May 11, 2005 12:09 pm
can you "ping" your server using the name from your PC? If not, use the IP address in the dsjob command line.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 15
- Joined: Wed May 11, 2005 12:09 pm
No, no separate file. I assume that you can use your DS clients from this PC without a problem, right?
It looks like a syntax error, but it works on my system in the same format. Might you have any embedded blanks or special characters in the command line? Try -lprojects option without giving a project name (which, BTW, is case sensitive...)
It looks like a syntax error, but it works on my system in the same format. Might you have any embedded blanks or special characters in the command line? Try -lprojects option without giving a project name (which, BTW, is case sensitive...)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 15
- Joined: Wed May 11, 2005 12:09 pm
Yes, all other DS clients work correctly, i.e.
DataStage Designer
DataStage Administrator
The closest I can get with all of my variations on syntax and parameters is the following which throws a "80011 - Incorrect system name or invalid user name or password provided." error.
C:\>"C:\Program Files\Ascential\DataStage7.5\dsjob.exe" -file "C:\Program Files\Ascential\DataStage7.5\ServerFile" 10.10.10.10 -lprojects
------------ServerFile begin------------
10.10.10.10, dsresource, abc123
------------ServerFile end------------
Thanks again for your assistance. It is interesting to note the command works on your system. Can you try the same as mine above?
DataStage Designer
DataStage Administrator
The closest I can get with all of my variations on syntax and parameters is the following which throws a "80011 - Incorrect system name or invalid user name or password provided." error.
C:\>"C:\Program Files\Ascential\DataStage7.5\dsjob.exe" -file "C:\Program Files\Ascential\DataStage7.5\ServerFile" 10.10.10.10 -lprojects
------------ServerFile begin------------
10.10.10.10, dsresource, abc123
------------ServerFile end------------
Thanks again for your assistance. It is interesting to note the command works on your system. Can you try the same as mine above?
Try another command,
"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h bigmachine /u arndw /p topsecretdoubleprobation /r * myproject
(this will compile all routines in project myproject)
Do you get the same error?
"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h bigmachine /u arndw /p topsecretdoubleprobation /r * myproject
(this will compile all routines in project myproject)
Do you get the same error?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 15
- Joined: Wed May 11, 2005 12:09 pm
This appears to work fine:
------------------
Intializing
Compiling "Job01" - Succeeded
Compiling "Job02" - Succeeded
Compiling "Job03" - Type cannot be compiled
Compiling "Job04" - Failed
etc.
Done.
------------------
"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h 10.10.10.10 /u dsresource /p abc123 /r * Project01
------------------
Intializing
Compiling "Job01" - Succeeded
Compiling "Job02" - Succeeded
Compiling "Job03" - Type cannot be compiled
Compiling "Job04" - Failed
etc.
Done.
------------------
"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h 10.10.10.10 /u dsresource /p abc123 /r * Project01
There is a hosts file that looks up IP addresses. It is usually in C:\WINDOWS\system32\drivers\etc. If you have an entry like
10.10.10.10 kimhp kimlaptop
Then kimhp and kimlaptop get transformed into 10.10.10.10.
Are all doing the same thing. The ping command tests to see if you can reach an IP address. If it can then it sends packets to this machine just see if it gets all of them and reports success or failures.
IP Addresses can also be transformed or resolved by your Domain Name Server. Proxy server can also do a similar function. They have a hosts file which they lookup a server name and change it to an IP Address like 1.2.3.4 or 10.10.10.10.
When you login to DataStage your server name gets resolved by these same processes. There are bridges and routers in between which also help connect you to your DataStage server but if you cannot ping it then you have a network problem.
Once you are talking to this server then you can either have a user password problem or DataStage is not listener is not working properly. So if you can login in with Designer then dsjob should work. If dsjob is not working then you have a syntax problem.
Walk down these steps until you eliminate each issue like network problems, user password problems and DataStage issues. When you make it work then post your solution so others can learn.
10.10.10.10 kimhp kimlaptop
Then kimhp and kimlaptop get transformed into 10.10.10.10.
Code: Select all
ping 10.10.10.10
ping kimhp
ping kimlaptop
IP Addresses can also be transformed or resolved by your Domain Name Server. Proxy server can also do a similar function. They have a hosts file which they lookup a server name and change it to an IP Address like 1.2.3.4 or 10.10.10.10.
When you login to DataStage your server name gets resolved by these same processes. There are bridges and routers in between which also help connect you to your DataStage server but if you cannot ping it then you have a network problem.
Once you are talking to this server then you can either have a user password problem or DataStage is not listener is not working properly. So if you can login in with Designer then dsjob should work. If dsjob is not working then you have a syntax problem.
Walk down these steps until you eliminate each issue like network problems, user password problems and DataStage issues. When you make it work then post your solution so others can learn.
Mamu Kim
-
- Participant
- Posts: 15
- Joined: Wed May 11, 2005 12:09 pm
Thank you for the explanation although I believe I have retraced all of the scenarios.
1. The IP address and server name do resolve using ping/nslookup.
2. I can log on to the AIX server with my user and password through telnet.
3. I can log on to DataStage Designer (10.10.10.10 and Project01) with my user and password.
4. I can successfully run the following command with my user and password:
"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h 10.10.10.10 /u dsresource /p abc123 /r * Project01
5. I don't believe I have a syntax error because the following command will throw a "80011 - Incorrect system name or invalid user name or password provided." error.
C:\>"C:\Program Files\Ascential\DataStage7.5\dsjob.exe" -file "C:\Program Files\Ascential\DataStage7.5\ServerFile" 10.10.10.10 -lprojects
------------ServerFile begin------------
10.10.10.10, dsresource, abc123
------------ServerFile end------------
The only other explanation is "DataStage listener is not working properly". Do you know how I can verify that piece?
1. The IP address and server name do resolve using ping/nslookup.
2. I can log on to the AIX server with my user and password through telnet.
3. I can log on to DataStage Designer (10.10.10.10 and Project01) with my user and password.
4. I can successfully run the following command with my user and password:
"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h 10.10.10.10 /u dsresource /p abc123 /r * Project01
5. I don't believe I have a syntax error because the following command will throw a "80011 - Incorrect system name or invalid user name or password provided." error.
C:\>"C:\Program Files\Ascential\DataStage7.5\dsjob.exe" -file "C:\Program Files\Ascential\DataStage7.5\ServerFile" 10.10.10.10 -lprojects
------------ServerFile begin------------
10.10.10.10, dsresource, abc123
------------ServerFile end------------
The only other explanation is "DataStage listener is not working properly". Do you know how I can verify that piece?
-
- Participant
- Posts: 15
- Joined: Wed May 11, 2005 12:09 pm
5. I don't believe I have a syntax error because the following command will throw a "80011 - Incorrect system name or invalid user name or password provided." error.
C:\>"C:\Program Files\Ascential\DataStage7.5\dsjob.exe" -file "C:\Program Files\Ascential\DataStage7.5\ServerFile" 10.10.10.10 -lprojects
------------ServerFile begin------------
10.10.10.10, dsresource, abc123
------------ServerFile end------------
Boy, I'm really at a loss on this one
C:\>"C:\Program Files\Ascential\DataStage7.5\dsjob.exe" -file "C:\Program Files\Ascential\DataStage7.5\ServerFile" 10.10.10.10 -lprojects
------------ServerFile begin------------
10.10.10.10, dsresource, abc123
------------ServerFile end------------
Boy, I'm really at a loss on this one