Just to add - I have checked all the posts and googles re this and the only solution is increase the UNDO space.
But if I am just doing read from the table, why do I have to worry about the UNDO space.
Search found 430 matches
- Thu Mar 06, 2014 12:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Real Time MQ job Error: ORA-01555: snapshot too old
- Replies: 2
- Views: 3154
- Thu Mar 06, 2014 12:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Real Time MQ job Error: ORA-01555: snapshot too old
- Replies: 2
- Views: 3154
Real Time MQ job Error: ORA-01555: snapshot too old
Hi, We have a RT job that is using MQ. It parses the XML message and it then runs few select queries on few tables. All queries here are sparse. All these tables are small except one. One of the table holds information that gets update in real time mode. So far things were running fine - except now ...
- Mon Mar 12, 2012 12:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 9
- Views: 6183
- Tue Dec 27, 2011 10:54 pm
- Forum: General
- Topic: Unable to install datastage
- Replies: 16
- Views: 35619
I have done one install and that was on Oracle. My current install is done by actual DS admin group. I was just going through the logs and what I saw was - host name mentioned was actual machine name. So rather than localhost, the name of the server (which comes from command uname -n ) is used. May ...
- Tue Dec 27, 2011 3:33 am
- Forum: General
- Topic: Compare Against/Cross Project Compare not available
- Replies: 8
- Views: 4770
- Tue Dec 27, 2011 3:09 am
- Forum: General
- Topic: Unable to install datastage
- Replies: 16
- Views: 35619
- Tue Dec 27, 2011 3:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read .req file in datastage
- Replies: 3
- Views: 3435
- Mon Dec 26, 2011 11:03 pm
- Forum: General
- Topic: Unable to install datastage
- Replies: 16
- Views: 35619
- Mon Dec 26, 2011 10:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookupstage issue
- Replies: 3
- Views: 3457
First thing - Close the other duplicate post. Second thing - when providing some job design or code and alignment is needed use the code button provided above and using the preview button make sure it looks the way you want it. Now coming to your problem - is there any warning or error in the job lo...
- Mon Dec 26, 2011 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformer not working on version 8.5
- Replies: 3
- Views: 5001
- Fri Dec 23, 2011 3:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Validate Rule
- Replies: 6
- Views: 3999
So for a single row there would be 150 rules and it needs to be matched with all of them or the first match should be considered? Assuming, the first match is considered - Is the rule only on two columns City and Country, or would it be on more columns as well. If just two columns, then a lookup/joi...
- Fri Dec 23, 2011 3:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get next value from DB Seq
- Replies: 20
- Views: 10968
From the OSH it looks fine to me. Would you be able to ask someone to monitor DB for what SQL is getting fired when the jobs runs and how many of them hit the DB? Also I have not used it but why not to use the SurrogateKey generator with the DB Sequence option. I do not know how it works, but I saw ...
- Wed Dec 21, 2011 11:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get next value from DB Seq
- Replies: 20
- Views: 10968
- Wed Dec 21, 2011 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Finding week and Month from Number
- Replies: 15
- Views: 7709
- Wed Dec 21, 2011 12:58 am
- Forum: General
- Topic: using text messages like a web service
- Replies: 4
- Views: 3791