DSXchange

Hi All, I found error message as follows: Fatal node_node1: APT_PMPlayer::APT_PMPlayer: pipe(STDERR) failed, File table overflow Fatal node_node1: Fatal Error: Unable to start ORCHESTRATE process: startPlayerSvc: Unable to create player 18 Fatal main_program: The Section Leader on node node1 has ter...

Sorry for the late reply. I can't change the OE execution mode since it's disabled --the value was default (sequential)--. Is it a normal setting from OE stage as a source stage? When I changed it into a target stage by removing the link and create a new one from OE stage into another, the execution...

Hamzaqk,
Do I need to restart the job monitor service? Since it worked for all jobs except this one?

Ray,
I changed the Combinality Mode setting on all stages (4 stages in this job) from Auto into Don't Combine. But it remained the same. JobMon didn't work.

Hi All, I have a problem on displaying Job Monitor. My case is as follows: 1. Extraction job: read from 2 Seq File stages and 3 Oracle Enterprise stages into 5 Dataset. This one had no problem on Job Monitor. 2. After some transformations, I have following load job Dataset--->Oracle Enterprise stage...

keshav, Thanks for your clue. And how about another question of mine? Should I disable those two variables to use AUTO partition in all stages? (not only in CC stage?)-- at whatever level-- My question is about impact the two env variables on stages. Do they just have impacts on CC stage (may produc...

keshav,
1. I tried your suggestion but the result was just the same. It produced DOUBLE DATA (for Index-Organized Table)
2. How do you think about weird results of ROWNUM in Where clause as I mentioned in previous post?

Thanks
Pratiyaz

I use auto partition on dataset. For additional info, I also tried to change the Index-Organized table into common table and it produced NO DOUBLE DATA. But in other case I tried to get a small part of big common table --approx 30 million rows-- (set Where clause with "rownum<100"), it als...

Thanks keshav, So as Nripendra said, I should set env variables APT_NO_SORT_INSERTION and APT_NO_PART_INSERTION into FALSE (disable) to use AUTO partition in all my jobs. Right? My next question, are those two env variables above need to set FALSE just in case of using CC stage? How about other stag...

Nripendra, Thanks for your reply. Based on your answer, I did searching in the documentation about env variables you mentioned. And I got this: *Parallel Job Advanced Guides* If data is pre-partitioned and pre-sorted , and the DataStage job is unaware of this, you could disable automatic partitionin...

Hi, I would like to use Change Capture (CC) stage for comparing old and current data. By some searching on this forum I get the point that I have to make sure that both input data (before and after) have the same partitioning and sorting methods. My questions are: 1. Do I HAVE TO use Sort stage on b...

Hi, I have a simple job to transfer data from Oracle Enterprise into a Dataset. The job get data from an Index-Organized table (11 rows), and it transfers 22 rows into Dataset. This job use default configuration file which has 2 nodes. Does anybody have any ideas on this? Is it a normal behavior of ...

Ok. Thanks Ray.

All, I tried to search on this forum but unfortunately did not get above topic spesifically. I have csv data as follows: DATE,DUMMY 1/2/2008 1:02:05,test 1/29/2007 11:11:34,test1 11/30/2007 10:39:24,test2 12/31/2008 4:39:24,test3 I uploaded into dataset (all varchars). Then did following transformat...