Page 1 of 1
How to can we get the details of a stage via unix
Posted: Tue Jul 19, 2011 4:31 am
by saj
Hi All ,
I want to know how we can get the stage names via unix commands .
I tried dsjob -lstages <project> <JobName>
But it is not providing exact info .
For eg it is not providing the oracle stage info .
Is there any other way to identify the same ?
Posted: Tue Jul 19, 2011 7:14 am
by chulett
That is the way. What exactly do you mean by "it is not providing the oracle stage info"?
Posted: Tue Jul 19, 2011 7:57 am
by saj
I have four stages .
Source is Oracle stage.From oracle stage we are loading the data into a hash file and from there via transformer into target table which is again a oracle table .
But when I fire this command it is not providing the source oracle info .
And for hash file it is giving with ".IDENT" extension .
Posted: Tue Jul 19, 2011 8:05 am
by chulett
Add a transformer between the source Oracle stage and the hashed file, see if that helps.
Posted: Tue Jul 19, 2011 8:54 am
by saj
The job is running fine . Issue is when I fire the dsjob lstages project jobaname command in unix it is not providing the stage names ..
Posted: Tue Jul 19, 2011 9:56 am
by fmou
Define "fine". chulett asked you to add a transformer, did you see that stage or not?
Posted: Tue Jul 19, 2011 10:03 am
by saj
Yes , I am able to see the transformer..
Posted: Tue Jul 19, 2011 10:19 am
by chulett
I'm lost... did you add the second transformer or not? If you did, did the list of stages work properly? I'm not expecting it to change the behaviour of the job itself, I'm hoping that adding it lets "-lstages" see everything.
Posted: Wed Jul 20, 2011 2:48 am
by saj
I added a second transformer . It is showing the transformer but not the oracle stages .....
Posted: Wed Jul 20, 2011 3:33 am
by ray.wurlod
Read about DSGetJobInfo() in the DataStage BASIC manual. There are different options to return different sets of stages; the default gives only the active stages. The dsjob -lstages command gives effect to this default. You can always modify the dsjob code.
Posted: Wed Jul 20, 2011 5:30 am
by saj
Ray ,
Can you please tell me where this information is present in the sever?
I mean which path ?
And how to retrieve this?
Since dsjob -lstages will be accessing some data which is present in the unix server ..
Any help will be appreciated greatly..
Posted: Wed Jul 20, 2011 7:01 am
by chulett
saj wrote:It is showing the transformer but not the oracle stages .....
Sorry, forgot that it only shows active stages.
Posted: Wed Jul 20, 2011 3:39 pm
by ray.wurlod
Code: Select all
SELECT NAME FROM DS_JOBOBJECTS WHERE OBJNAME LIKE 'V%S%' AND OBJNAME NOT LIKE 'V%S%P%' AND OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<JobName>>');