Job search in unix

mayura · Post by **mayura** » Fri Sep 24, 2010 5:45 am

how to search the data stage job in unix..

chulett · Post by **chulett** » Fri Sep 24, 2010 5:56 am

Please define what you mean by "search the DataStage job".

ray.wurlod · Post by **ray.wurlod** » Fri Sep 24, 2010 3:01 pm

Search DSXchange. There is a recent (current) conversation about UNIX processes that belong to a DataStage job.

The job itself does not exist in UNIX. The job itself is stored in database tables.

mayura · Post by **mayura** » Mon Sep 27, 2010 12:08 am

ray.wurlod wrote:Search DSXchange. There is a recent (current) conversation about UNIX processes that belong to a DataStage job.

The job itself does not exist in UNIX. The job itself is stored in database tables. ...

there is datastage and unix connectivity.In version 8 we can seach the job.But in 7.5 suppose for example i have created a job and i dont remind in which category it is,Then how can we seach it by using UNIX.
As i know we can search it from datastage admin but how from UNIX.

udayk_2007 · Post by **udayk_2007** » Mon Sep 27, 2010 2:40 am

you can fire a query on database from unix box.

select category from ds_jobs where job_name='your job name'

mk_ds09 · Post by **mk_ds09** » Mon Sep 27, 2010 5:18 am

Before running query you have to check for UV command.
You need to setup the datastage enviormental variable.
And if there are multiple projects, you have to logon on those projects and then you can check the job specific properties as well..

One UV is set, you can query datastage tables to get the details of the job.

If your job is not present , query will fail ..

Hope this helps

mayura · Post by **mayura** » Tue Oct 05, 2010 3:55 am

mk_ds09 wrote:Before running query you have to check for UV command.
You need to setup the datastage enviormental variable.
And if there are multiple projects, you have to logon on those projects and then you can check the job specific properties as well..

One UV is set, you can query datastage tables to get the details of the job.

If your job is not present , query will fail ..

Hope this helps

thx .. but still me not satisfied with result... will search .. lets see..

chulett · Post by **chulett** » Tue Oct 05, 2010 6:41 am

Roll your eyes all you like, that *is* your answer. Search the forum for "dssh" to find examples how to fire that Universe query from the command line, the exact same query you would use at a TCL prompt or from the Administrator client.

And don't forget you can always use the Director for this - filter based on the job name and turn off the display of categories and it will find it for you.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 05, 2010 3:32 pm

Given that you have version 8, you also have Quick Find and Advanced Find in the Designer client.