How to can we get the details of a stage via unix

saj · Post by **saj** » Tue Jul 19, 2011 4:31 am

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 ?

chulett · Post by **chulett** » Tue Jul 19, 2011 7:14 am

That is the way. What exactly do you mean by "it is not providing the oracle stage info"?

saj · Post by **saj** » Tue Jul 19, 2011 7:57 am

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 .

chulett · Post by **chulett** » Tue Jul 19, 2011 8:05 am

Add a transformer between the source Oracle stage and the hashed file, see if that helps.

saj · Post by **saj** » Tue Jul 19, 2011 8:54 am

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 ..

fmou · Post by **fmou** » Tue Jul 19, 2011 9:56 am

Define "fine". chulett asked you to add a transformer, did you see that stage or not?

saj · Post by **saj** » Tue Jul 19, 2011 10:03 am

Yes , I am able to see the transformer..

chulett · Post by **chulett** » Tue Jul 19, 2011 10:19 am

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.

saj · Post by **saj** » Wed Jul 20, 2011 2:48 am

I added a second transformer . It is showing the transformer but not the oracle stages .....

ray.wurlod · Post by **ray.wurlod** » Wed Jul 20, 2011 3:33 am

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.

saj · Post by **saj** » Wed Jul 20, 2011 5:30 am

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..

chulett · Post by **chulett** » Wed Jul 20, 2011 7:01 am

saj wrote:It is showing the transformer but not the oracle stages .....

Sorry, forgot that it only shows active stages.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 20, 2011 3:39 pm

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>>');