DSXchange

What command to be given in DS Admin console to find a job?

Also, can anyone suggest me a place where I will find a comprehensive list of commands to be given at Command interface with DS Administrator?

Hello Videsh,

The Administrator is not the right place to look for jobs, that is best done in any of the 3 other programs. The command line calls are not needed for normal day-to-day DataStage work, therefore they are not documented in detail in the DataStage product. The underlying engine is almost identical to IBM's "UniVerse" product; if you go to IBM's website and search for universe documentation you will find several PDF documents detailing more information about what you can do from the command line than you can shake a stick at.

http://www-306.ibm.com/software/data/u2 ... y/952univ/

and I'd look at the http://www-306.ibm.com/software/data/u2 ... 04-952.pdf (the user guide).

I just noticed that I linked to the 9.5.2 documentation, the 10.x is on IBM's site as well.

ArnW, Thanks for the links.

But it didnt solve my problem. I am having many jobs in my project, which are classified under different categories.

I need to know, given a command & a jobname it will tell me which category that job resides.

videsh77 wrote:What command to be given in DS Admin console to find a job??

The only command you can give is a DS Engine command, and the DS Engine is a code branch of IBM's Universe product, therefore Arnd has pointed you in the right direction. Look here for commentary:
viewtopic.php?t=87916&highlight=dsjobs+category

videsh77 wrote: Also, can anyone suggest me a place where I will find a comprehensive list of commands to be given at Command interface with DS Administrator?

Arnd has done so.

In DataStage Director, under view in the menu, click on "Show All" and/or unclick on "Show Categories". One of these combinations will dispaly all jobs in the project.

Larry

Check this post for the syntax you are looking for.

Thanks Craig & ArnW

SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'JobName';

It will give you the category in which your job resides.