dsjob call from PC to AIX

[kduke]

Your syntax looks correct. Maybe your server is not in your PC host file or your password is incorrect.

[charles.craig@physiciansm]

The password is correct for the user I am specifying.

I don't recognize the "PC host file" you refer to. Can you elaborate?

Thanks again!

[ArndW]

can you "ping" your server using the name from your PC? If not, use the IP address in the dsjob command line.

[charles.craig@physiciansm]

I can ping/nslookup and see the ip address and name of the server from the PC.

I have used the IP address and name of the server both in the dsjob command.

I have used my id+password and root id+password.

Is there a "PC host file" for DS I need to update?

[ArndW]

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...)

[charles.craig@physiciansm]

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?

[ArndW]

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?

[charles.craig@physiciansm]

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

[kduke]

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.

Code: Select all

ping 10.10.10.10
ping kimhp
ping kimlaptop

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.

[charles.craig@physiciansm]

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?

[charles.craig@physiciansm]

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