Page 1 of 1
DataStage 8.0 dsjob command error
Posted: Fri Mar 13, 2009 3:45 pm
by gsbrown
I'm trying to get a dsjob command line executed for starting a DataStage job in 8.0
This command works....
C:\IBM\InformationServer\Server\DSEngine\bin\dsjob -server DWAPP02 -user userid -password password -run DWProd lkpbldDMDATE
This command does not work...
C:\IBM\InformationServer\Server\DSEngine\bin\dsjob -file d:\apps\signon.file DWAPP02 -run DWProd lkpbldDMDATE
And inside the signon.file I have...
DWAPP02,userid,password
What would be the difference between these two commands that causes the second command to return "Failure to locate information for server"?
Posted: Fri Mar 13, 2009 5:41 pm
by chulett
Not sure unless it's horked up in 8. I've used the latter syntax without issue in 7.x on a UNIX server and from memory what you posted looks correct to me.
Posted: Fri Mar 13, 2009 6:20 pm
by lstsaur
Well, the latter syntax is working for me in V8 Linux. It's got to be something specific for the "Windows" platform.
Posted: Fri Mar 13, 2009 7:07 pm
by ArndW
Don't you still need the "-mode NORMAL"?
Posted: Sat Mar 14, 2009 12:29 am
by ray.wurlod
Which particular Windows platform? This might be one of those things that Windows XP does not support (though the fact that it worked pre version 8 is a bit of a poser). But version 8 is a radically different beast in any case.
Posted: Wed Mar 18, 2009 8:33 am
by gsbrown
Thanks Len, I think that might have gotten me further.
Now I'm getting this error....
Code: Select all
C:\Documents and Settings\dsiisadmin>C:\IBM\InformationServer\Server\DSEngine\bi
n\dsjob -file d:\apps\signon.file NONE DWAPP02 -run DWProd lkpbldDMDATE
ERROR: Failed to open project
Status code = -1010 DSJE_DOMAINLOGTOFAILED
I know I've got the userid/password correct, and I'm assuming I have the engine and project name correct because I can get a version of this command to work (see original post) using the same engine and project name.
I've also got a support case open with IBM on this so I may give up for now and wait on their feedback. Thanks for the responses so far!
Posted: Fri Mar 20, 2009 2:05 pm
by gsbrown
Replacing NONE with my actual domain DWAPP02:9080 makes this command work!
Code: Select all
C:\Documents and Settings\dsiisadmin>C:\IBM\InformationServer\Server\DSEngine\bi
n\dsjob -file d:\apps\signon.file DWAPP02:9080 DWAPP02 -run DWProd lkpbldDMDATE
Also had to make sure my signon.file contained...
DWAPP02:9080,DWAPP02,userid,password
Posted: Fri Mar 20, 2009 3:13 pm
by chulett
Thanks for posting the resolution to this.
Posted: Mon Oct 26, 2009 9:25 am
by battaliou
Yes, thanks for the resolution, on AIX 8.1 you use a similar method, with a comma separated config file. I had the added joy of setting a project defined parameter.
$ dsjob -file myfile.pas server:9080 server -run -param '$stageusr=paramuser' Project Jobname
$ cat myfile.pas
server:9080,server,user,password
Posted: Mon Sep 20, 2010 1:37 pm
by asorrell
I'm going to add an additional note to this, even though its resolved...
I've just found out that the case of the domain / servername must match the case returned by the "hostname" command.
For example:
$ hostname
MyServer
$
Means that you'd better have
MyServer:9080,MyServer,username, password
in the file. MYSERVER and myserver won't work!
Posted: Tue Aug 30, 2011 1:50 pm
by dsnovice
Posted: Tue Aug 30, 2011 1:56 pm
by dsnovice
Thank you very much for posting the resolution. It worked great!!. and yes its case sensitive.
