How to find the files being used in which all jobs?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 15, 2006 12:23 pm
How to find the files being used in which all jobs?
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???
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
How to find the files being used in which all jobs?
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]
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]
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
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
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>'