DSXchange

We can read and insert and update data without any problems, but if we have for instance space issue in one partition, then it fails with this type of statement SQL Failed And just repreats the SQL-code send to DB. If we try the same using pure SQL in for instance sqlplus or toad then we get the ORA...

Hi, I have a strange problem, most likely, caused by some environment property that I do not know. We are trying to switch from DB2 to Oracle 11g. We configured dsenv to use a Oracle Client 10 and Oracle Connector Stage variant 10 and it worked and returned ORA messages in the director log as expect...

Sounds strange to me! As far as I know you can't use sparse lookup using DB2 API stage and you can't use DB2 Enterprise stage to connect to Mainframe DB2 (at least not from Unix)....

As far as I know and understand this... (I have only been utilizing DB2 and DB2EE-stages in heterogeneous environments) When using the DB2EE-stage and plain user-defined SQL; At runtime the DB2EE-stage will operate in sequential mode and thereby operating via the client. This part works in theory wi...

DataSet [ 5.5 mil records, 250 fields] | | Sequential file --> Lookup --> Transfomer --> Filter ----> Funnel --> Dataset [1 record, [9 links out 2 fields] from filter] I would suggest flipping this job so you can enable streaming of data. This approach needs to buffer all 5.5 million lookup records...

Follow fridge's lead....

You also need to watch out as I believe DSV8 can talk to both V8 and V9 of DB2 - however if you dont specifiy db2 version at install time then wont create the following link correctly

orchdb2op -> orchdb2op8.o

I've read his blog and it gave me a few insight, but I always want more Thanks all!

Is there anything to gain by being connected to the new repository? Maybe some new functionality is available? Metadata benefits etc... The plan is to slowly transition some jobs to parallel were needed, and IBM demands us to upgrade to 8.1, which costs a lot more than the license we are using curre...

Hi, I would like to know if anyone has had any experience with a Datastage Server Edition upgrade/migration to Informational Server, not converting jobs to parallel... Is it a simple operation or are there any types of jobs that doesn't run on 8.1 without re-programming. I know its a touch question ...

You have to have the px engine library available on the remote db2 machine (and or db2 nodes) and the ability to connect to that machine using rsh or ssh (using remsh.sh in ds-lib) if you wish to use the db2 enterprise stage. Furthermore the os and hardware of those platforms need to match.... The A...

If it is indeed a csv or skv or any -separated file, then your problem probably is on the last or second last column if the last column is empty. Some versions of Excel seems to export data skipping empty fields at the end. This means that datastage will find an early end marker and skip or reject t...

tested it after the post a couple of weeks(running 8) the restriction is still there. But perhaps I didn't get it quite right: (A) One can define multiple readers on a single node with variable lenght records. I played around today and see that one can increase read speed by specifying multiple rea...

Rajee, Try what ArndW is saying How many columns does the file have and how long does it take to read the file when the only other stage in your job is a copy stage (or a peek stage)? To see how long the actual file reader stage executes. If it is indeed 35 min then you know for sure that the sff-st...

Depending on your datastage version you can improve performance (with varied results) based on how your file is structured using sequential file stage by setting the following properties in it. Read From Multiple Nodes = Yes or Number of Readers Per Node = N Furthermore, your performance is also dep...

I guess you've configed remsh to ssh and that you've tried executing some command on the remote server using remsh-command. If that works and you're configuration-file still doesn't work, re-check any spelling misstakes and try with rsh. If that works then ssh might not work in you're enviroment.