DSXchange

Also I would like to fetch out some information which can help us to do the version control of Datastage jobs. Ascential Claims that the Version control offered by them is not very efficient. Also I have heard that it is not recommended for the use. Please correct me if I'm wrong Current Version Con...

Hello, I want to know about some functionality of DS. Manager tat will help me Exporting multiple jobs from a project and making individual .dsx files. Can this be done in one go? Or I need to export the jobs one by one? The reason for export of individual jobs is that I want to commit the jobs into...

Hi All, We have created a job like ODBC -> Transformer -> Oracle -> Transformer -> ODBC In this job we have enabled the Output Reject Records option for rejected records and we want insert these rejected records into SQL Server table (as ODBC stage). We have tried with all the below options, but in ...

Hello there, I have used an Aggregator Stage by the name Agg_Check in my job . Since the field "FIELD1" is a Bigint (int 64). So the Aggregator complains the following error message: Can you please let me know the reason for such a response from Datastage? Agg_Check : Error when checking o...

Hello , I had 3 jobs sequenced ina job sequencer and while running the jobs i encounterred a problem : PROBLEM Sequencer name : SeqInit1000_3001_3002 Job name : Extract_030_Card1000_StartFile While this job was being run the job sequencer failed by giving the following error message : "SeqInit1...

Hello , I had 3 jobs sequenced ina job sequencer and while running the jobs i encounterred a problem : PROBLEM Sequencer name : SeqInit1000_3001_3002 Job name : Extract_030_Card1000_StartFile While this job was being run the job sequencer failed by giving the following error message : "SeqInit1...

Is there any way by which we can find out the which all jobs use a dataset that has been created I mean that If a parallel job creates a dataset . Now we shall be using that dataset across various jobs . So i want to know that can we determine that which alll jobs use this dataset by looking at the ...

ray.wurlod wrote:First off, disable operator combination so you can work out which operator is having the problem.

Resource disk is used only for Data Sets and File Sets. If it turns out that the stage having the ...

Ray can you please tell me how to Disable Oerator Combination and what exactly it is ??

What do Datastage means when it says while starting a parallel job giving the message :
DSD.StageRun Active stage starting, tracemode = 0.

Thanks Ray For the information, But then what role DISK SPACE plays?? Also I tried to run the job again... The job is failing again saying that "APT_CombinedOperatorController,0: write failed: Output file full, and no more output files" But when I check the corresponding UNIX directory I s...

Hello there... Well I have this job running at the client end and it processes real heavy gusts of data... Now some time back the jobs fails saying "APT_CombinedOperatorController,0: write failed: Output file full, and no more output files write failed: Output file full, and no more output fil...

It is NOT possible to perform a lookup in a Transformer stage using Data Sets. The parallel Transformer stage does not support reference inputs. At all. ... I know that I was not clear in stating my earlier comments,but i was referring to server jobs only . :) I know that a transformer doesnot supp...

yes I'm aware of the fact that lookup is done via a transformer stage . Also to add to this we can always perform look up in a transformer using datasets too. but My question is that why at all datastage makers decided to provide this functionality in a transformer stage and did not allow look up st...

Hello alll,

I have a basic question for which i could not find an answer.

Why in datastage we dont have Look=up stage ina server job ?

I tried to figuer out but could'nt find an answer to it .
Can someone throw some light on it ??

The job that is sequenced is in Finished state but the sequencer aborts any further execution complaining this error. Remember this scenario happens once i have my previous run as aborted and I reset the aborted job. eg A-->b-->c-->d [Concider a,b,c,d as jobs sequenced] First Run --> a sucess-->b su...