Search found 20 matches
- Wed Apr 10, 2019 5:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Factors to decide the run mode of Oracle connector
- Replies: 5
- Views: 4862
- Wed Apr 10, 2019 12:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Factors to decide the run mode of Oracle connector
- Replies: 5
- Views: 4862
Yes we have tried with Rowid round robin method but no luck. It is taking almost the same time as rowid range method. We have another job which is extracting the data from table1 and processing is done in transformer and aggregator stages and there is no join/lookup stage. In this job the elapsed ti...
- Mon Apr 08, 2019 12:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Factors to decide the run mode of Oracle connector
- Replies: 5
- Views: 4862
Factors to decide the run mode of Oracle connector
Hi, We are doing performance testing We are reading data from an oracle table in the oracle connector stage. The query used is select col1,col2,col3 from table1 where col2='Z' The query returns 50 million records. We are reading data from another oracle table select col1,col2,col3 from table2 where ...
- Sun Mar 10, 2019 6:25 am
- Forum: General
- Topic: how much Ram, CPU and Disk Space we need
- Replies: 4
- Views: 3572
- Thu Mar 07, 2019 11:10 pm
- Forum: General
- Topic: how much Ram, CPU and Disk Space we need
- Replies: 4
- Views: 3572
how much Ram, CPU and Disk Space we need
Hi DSGurus, We are working on Data Migration project. Our source is Oracle and target system is also Oracle. We will be designing parallel jobs. There are about 40 source tables to be read and 57 target tables to be loaded. Data volume to be loaded is about 50 million records. We need to decide on t...
- Tue Jan 29, 2019 7:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to abort job when a string value is in a decimal field?
- Replies: 1
- Views: 2797
How to abort job when a string value is in a decimal field?
Hi, We are getting a string value 'NULL' in a field Col1 from a sequential file. This field needs to be mapped to a decimal field in Oracle as null value. We are using Oracle connector stage as target. The job is not aborting when we are running this scenario. Zeroes are getting populated in the tar...
- Mon Sep 03, 2018 9:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Jobs are aborting
- Replies: 6
- Views: 3686
Re: Parallel Jobs are aborting
Yeah chulett... your are right. I have added ## only in the error message.
Yes, all the jobs are aborting and they were working fine before.
The hostname is correct and we are able to connect to the host through designer and administrator clients. There are not changes in the config file as well.
Yes, all the jobs are aborting and they were working fine before.
The hostname is correct and we are able to connect to the host through designer and administrator clients. There are not changes in the config file as well.
- Fri Aug 31, 2018 2:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Jobs are aborting
- Replies: 6
- Views: 3686
Parallel Jobs are aborting
Hi, The parallel jobs are aborting with the below error- main_program: APT_PMaddrInfoFor(): getaddrinfo(host = #hostname#, port = ) failed with error -2 - Name or service not known: node #hostname# cannot be used. Please note: I have replaced the actual host name with #hostname# in the above error. ...
- Mon May 21, 2018 10:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector stage not rejecting data truncations errors
- Replies: 6
- Views: 6054
- Tue May 15, 2018 5:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector stage not rejecting data truncations errors
- Replies: 6
- Views: 6054
When I increase the length of the field ()i.e varchar 15) in the Input tab of Oracle connector, then the record gets rejected from Oracle connector stage. Yes even I think DataStage is truncating the data before sending it to Oracle but I dont see any warning messages in the log. Is there any patch/...
- Sun May 13, 2018 8:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector stage not rejecting data truncations errors
- Replies: 6
- Views: 6054
- Fri May 11, 2018 12:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector stage not rejecting data truncations errors
- Replies: 6
- Views: 6054
Oracle connector stage not rejecting data truncations errors
Hi, I am loading data to oracle database using Oracle connector stage as my target. The source column is varchar 20 and target oracle column is varchar2(10). I have put a reject link from the target oracle connector stage and have checked the data truncation errors check box in the reject link. But ...
- Fri Oct 20, 2017 4:16 am
- Forum: General
- Topic: Unable to connect to SQL server through DataStage
- Replies: 1
- Views: 2523
Unable to connect to SQL server through DataStage
Hi, The DataStage server is on unix. We are unable to connect to SQL server through DataStage. We are trying to import table definitions using ODBC table definition. After selecting the DSN from the drop down list and giving the username and password and clicking Import, we get an error message- SQL...
- Tue May 05, 2015 12:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with External source stage hangs
- Replies: 4
- Views: 2780
- Mon May 04, 2015 11:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with External source stage hangs
- Replies: 4
- Views: 2780
Job with External source stage hangs
We have a job that reads from external source stage. The source program given in this stage is "sh filename". The volume of souce data is 193 million rows. The job hangs after reading 17 million rows. Is there any limitation for External source stage? If this stage is replaced with sequent...