DataStage 8.0 dsjob command error

gsbrown · Post by **gsbrown** » Fri Mar 13, 2009 3:45 pm

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"?

chulett · Post by **chulett** » Fri Mar 13, 2009 5:41 pm

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.

lstsaur · Post by **lstsaur** » Fri Mar 13, 2009 6:20 pm

Well, the latter syntax is working for me in V8 Linux. It's got to be something specific for the "Windows" platform.

ArndW · Post by **ArndW** » Fri Mar 13, 2009 7:07 pm

Don't you still need the "-mode NORMAL"?

ray.wurlod · Post by **ray.wurlod** » Sat Mar 14, 2009 12:29 am

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.

gsbrown · Post by **gsbrown** » Wed Mar 18, 2009 8:33 am

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!

gsbrown · Post by **gsbrown** » Fri Mar 20, 2009 2:05 pm

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

chulett · Post by **chulett** » Fri Mar 20, 2009 3:13 pm

Thanks for posting the resolution to this.

battaliou · Post by **battaliou** » Mon Oct 26, 2009 9:25 am

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

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Sep 20, 2010 1:37 pm

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!

dsnovice · Post by **dsnovice** » Tue Aug 30, 2011 1:50 pm

dsnovice · Post by **dsnovice** » Tue Aug 30, 2011 1:56 pm

Thank you very much for posting the resolution. It worked great!!. and yes its case sensitive.