DSXchange

We understand that performance can be improved by indexing and partitioning on database side. But we want to know from DataStage end what all can be done to improve the performance.

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...

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 ...

yes, it is a one time load... we need a rough estimate of the space,cpu and ram that is required for this load.
are there any standards to calculate the number of nodes,ram,disk space needed to process the data based on the volume of data?
please suggest

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...

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...

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.

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. ...

Hi,

Any patch/environment variable setting is available to suppress the truncation of data?
Please provide suggestions.

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/...

I have tried inserting into Oracle table using TOAD, but I get an error saying that the number of characters exceeding the length.
But I am surprised why am I not getting this error while running the job in DataStage.

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 ...

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...

The filename is a file with unix commands to get data from different files.

But I want to know the reason why 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...