How to find the files being used in which all jobs?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ahmedwaseem2000
Premium Member
Premium Member
Posts: 145
Joined: Fri Sep 15, 2006 12:23 pm

How to find the files being used in which all jobs?

Post by ahmedwaseem2000 »

Hi - How can I find about which all job's are using a particular file? I know that dssearch can be used to find the jobs but how do I do for the files???
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I prefer to use Usage Analysis on the table definition imported from the file. But, then, I am rigorous in preserving the links between the table definitions and the jobs that use them. Are you?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Srdhr.B
Participant
Posts: 1
Joined: Sun Jul 27, 2008 2:15 am
Location: Hyderabad

How to find the files being used in which all jobs?

Post by Srdhr.B »

Hello Ray,

Could you explain me how we can find the job, if the meta data or table definition is not imported? And they have been hard coded mannually?

Is t here any other option in DataStage 7x (Server Jobs) ratherthan Usage Analysis?

Thanks in advance for your inputs.

[quote="ray.wurlod"]I prefer to use Usage Analysis on the table definition imported from the file. But, then, I am rigorous in preserving the links between the table definitions and the jobs that use them. Are you? ...[/quote]
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

One way would be to export the project and then manually search the dsx file. Or use a utility like Chuck Smith and others have built to help in the search.
-craig

"You can never have too many knives" -- Logan Nine Fingers
OddJob
Participant
Posts: 163
Joined: Tue Feb 28, 2006 5:00 am
Location: Sheffield, UK

Post by OddJob »

As Craig suggests, I have used 'List all files and tables used by jobs in a dsx file' tool (!!) to good effect.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yup, we load the output into an Oracle table so we can query it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
throbinson
Charter Member
Charter Member
Posts: 299
Joined: Wed Nov 13, 2002 5:38 pm
Location: USA

Post by throbinson »

If by file you mean a Sequential File stage as input/output then this may save you a step;

Code: Select all

SELECT 
 DS_JOBS.NAME AS JOB_NAME FMT '35L',
 DS_JOBS.CATEGORY AS JOB_CATEGORY FMT '35L',
 EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILENAME FMT '35L' 
FROM 
   DS_JOBOBJECTS
   , DS_JOBS 
WHERE 
   DS_JOBOBJECTS.OLETYPE IN ('CSeqInput','CSeqOutput')
AND DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO
AND FILENAME = '<your filename>'
Post Reply