DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
ahmedwaseem2000



Group memberships:
Premium Members

Joined: 15 Sep 2006
Posts: 145

Points: 1124

Post Posted: Tue Sep 02, 2008 10:43 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: ?
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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Tue Sep 02, 2008 11:33 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Srdhr.B
Participant



Joined: 27 Jul 2008
Posts: 1
Location: Hyderabad
Points: 5

Post Posted: Thu Sep 11, 2008 6:01 am Reply with quote    Back to top    

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]
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Thu Sep 11, 2008 7:25 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
OddJob
Participant



Joined: 28 Feb 2006
Posts: 163
Location: Sheffield, UK
Points: 1000

Post Posted: Thu Sep 11, 2008 8:11 am Reply with quote    Back to top    

As Craig suggests, I have used 'List all files and tables used by jobs in a dsx file' tool (!!) to good effect.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Thu Sep 11, 2008 8:44 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
throbinson


since April 2010

Group memberships:
Premium Members, Heartland Usergroup

Joined: 13 Nov 2002
Posts: 299
Location: USA
Points: 1780

Post Posted: Thu Sep 11, 2008 10:41 am Reply with quote    Back to top    

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

Code:

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>'
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours