DSXchange

Certain jobs that use them get unexplained mutex errors that cause the jobs to abort. Are there certain scenarios when they should not be used?

Does anyone have a sample odbc.ini entry for a MS ACCESS database.

Is anyone aware of issues with using link collector stage or link partitioner stage

You should be able to stream 70 million rows in an hour or two. After that you can stream only the changed rows, if you have some way of detecting them. I have been in touch with Ascential and they stated that the DB2 odbc driver for unix does not translate iseries signed numeric data types to the ...

Ray,
unfortunately the table in question will contain 70 million rows therefore it won't be practicable to download it to the local server everynight. Any other thoughts?

Hello...... I am trying to access a db2 table on the iseries using an ODBC stage. I have configured the odbc.ini file to use a db2 wired protocal driver - Driver=/usr/local/ascential/Ascential/DataStage/branded_odbc/lib/VMdb220.so Description=DataDirect 4.20 DB2 Wire Protocol D20ver. The signed nume...

I'm trying to preload a hash file of size 151MB with unix ulimit settings of time(seconds) unlimited file(blocks) unlimited data(kbytes) 460800 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 Datastage aborts but when I set the preload option off the job r...