Search found 71 matches
- Wed May 20, 2015 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join on large file takes long time
- Replies: 2
- Views: 2772
- Mon May 18, 2015 3:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join on large file takes long time
- Replies: 2
- Views: 2772
Join on large file takes long time
I would appreciate your opinion on a join that I need to do but it's taking way too much time. I must be missing some important point here. File 1: 118 rows (eventually should be 8,000,000+) Dataset hash partitioned, sorted by key (not unique) File 2: 21,000,000 rows Dataset hash partitioned, sorted...
- Mon Dec 08, 2014 10:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connection to HDFS through BDFS Stage
- Replies: 5
- Views: 4865
- Thu Nov 20, 2014 8:12 am
- Forum: General
- Topic: Monitoring DataStage jobs with Nagios
- Replies: 3
- Views: 3594
- Wed Nov 05, 2014 9:17 am
- Forum: General
- Topic: Monitoring DataStage jobs with Nagios
- Replies: 3
- Views: 3594
Monitoring DataStage jobs with Nagios
I would like to hear solutions and your experiences with monitoring DataStage jobs from Nagios or from any other external tool.
The requirement is to raise alerts on all jobs that finish with status <> OK, preferably real time or to run a scan every 10 minutes.
The requirement is to raise alerts on all jobs that finish with status <> OK, preferably real time or to run a scan every 10 minutes.
- Sun Aug 10, 2014 2:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Missing record delimiter "\n", saw EOF instead
- Replies: 22
- Views: 44768
- Mon Dec 03, 2012 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector - bulk load fails if not the table owner
- Replies: 5
- Views: 6242
Re: Oracle connector - bulk load fails if not the table owne
hi
did anyone find an explanation to this problem ?
is it a know issue ?
did anyone find an explanation to this problem ?
is it a know issue ?
- Tue Oct 30, 2012 1:22 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Web Service invocation fails
- Replies: 3
- Views: 6019
Thanks for your reply. Unfortunately there is no http edition. I've tried http service I found in internet: http://www.restfulwebservices.net/wcf/WeatherForecastService.svc and it works fine. According to sysadmin who's responsible for the requred https - there is no need in user/password or certifi...
- Mon Oct 29, 2012 8:02 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Web Service invocation fails
- Replies: 3
- Views: 6019
Web Service invocation fails
In DataStage 8.5 I'm using Web_Services_Transformer to invoke a Web Server. I've loaded the WSDL file and the port address starts with "https". I checked the WS via soapUI and it does not requires token (user/password) or certification. But if in Web_Services_Transformer in the Secutiry ta...
- Wed Mar 14, 2012 2:00 am
- Forum: General
- Topic: DataStage Designer collides with QTP -QuickTest Professional
- Replies: 4
- Views: 3550
DataStage Designer collides with QTP -QuickTest Professional
Hi, Did anyone noticed a collision between DataStage Designer (8.1) and QTP installed on the same client machine? For some reason, QTP will stop working after installation of Designer. On the other hand, when QTP is installed after Designer, all Connector stages will not show the properties page... ...
- Mon Oct 10, 2011 6:42 am
- Forum: General
- Topic: DB trace shows a select from non-exist MetaStage_Loc_Info
- Replies: 4
- Views: 4111
- Mon Oct 10, 2011 5:32 am
- Forum: General
- Topic: DB trace shows a select from non-exist MetaStage_Loc_Info
- Replies: 4
- Views: 4111
It makes me wonder why would one bother to answer, while providing no answer at all... :shock: Isn't it a waste of his time? No, I did not find a solution in the DSXchange forum (but did search it). My believe is that sharing knowledge makes you a greater man. Hiding it, makes you ...?!. Think of th...
- Mon Oct 10, 2011 4:22 am
- Forum: General
- Topic: DB trace shows a select from non-exist MetaStage_Loc_Info
- Replies: 4
- Views: 4111
DB trace shows a select from non-exist MetaStage_Loc_Info
Hi Everyone, DBAs reported this recurring Oracle error (942): a select from non existing table METASTAGE_LOC_INFO. This faulty select statement is generated and called from DataStage jobs, but error is not reported in the DS log. It is found when a DB trace is activated by DBAs. From reading earlier...
- Thu Jun 23, 2011 4:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CLOB issues
- Replies: 3
- Views: 3950
CLOB issues
Hi I need to move 2.5 million records per day from one oracle DB to another oracle DB. The source and target table are the same The tables have 3 CLOB fields all of them must move to the targent After reading the forum and IBM docs I defined a parallel job with 2 oracle connectors. The only way I ca...
- Thu Apr 21, 2011 1:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change default value of attribute in oracle stage
- Replies: 3
- Views: 3720
Change default value of attribute in oracle stage
Hi
Does any one know if it's possible to change default values of attribute in datastage stage -> I want to change the default value of the sql before statement in oracle stage
In the client when I logged in with admin - the stage open in read-only mode
Thanks
Does any one know if it's possible to change default values of attribute in datastage stage -> I want to change the default value of the sql before statement in oracle stage
In the client when I logged in with admin - the stage open in read-only mode
Thanks