DSXchange

Version 7.5 complains on the number of CPU's but happily seems to continue working (must be a bug in the software ).

We also had problems with dual-core cpu's which Ascential counts as 2 separate cpu's.

Ogmios

A hunch: the definition of your primary key in Oracle and in the DataStage job are not the same. Put them to the same and your error will disappear.

Ogmios

It's not built in into DataStage as such, you have to implement the functionality yourself. E.g. if the records you move contain a (rising) surrogate id, you can do a query on the target for the maximum already loaded surrogate id and integrate this in the original job. Before executing the real job...

DataStage Version control works in mysterious ways... we got rid of it in every place.

Ogmios

Go back to the person who gave you the assignment. A transaction size of 0 means you only commit once after everything is complete, which is in the case of Oracle very good if you transaction fits in the undo tablespace.

Ogmios

There's no skip for the jobs in use... we've been "harassing" Ascential for this since v4.

Ogmios

Your DB2 administrators can also make the warning go away by changing a setting on the db2 side, never bothered so far to find out just what setting it is.

Ogmios

First check your diskspace (whether you're not in a disk full condition).

Secondly try to cut your imports in smaller pieces, v5 had some problems with very big import files.

Ogmios

you have to shell-out from datastage to do the import... import is not 'SQL', you need a db2 shell to be able to do it.

Ogmios

chinek wrote:hi
....

Thanks for the help ogmios.

Nick

Forgot about the not being required to bounce . By the way the solution is from Ascential, it only took them about half a year to figure that out

Ogmios

For a leap of faith. Change your dsenv in the following way: Add "/usr/lib/lpw" in front of the LD_LIBRARY_PATH, restart DS and your problem will magically disappear :wink: So it should be something as LD_LIBRARY_PATH=/usr/lib/lwp:... This is a work around for a known thread problem in Sol...

Phil, according the W3C XML standard the carriage return as well as the line feed character is considered whitespace... I appologise sincerely for disparaging DataStage in this way. I am evidently mistaken. Nonetheless, the question stands, is it important that these files be kept this way, or can ...

Search this site for "unlock"... what's also important is to release the locks (the bottom half of the screen instead of the top half you're using now).

Ogmios

STORE is the internal ftp command for "put" when SUNIQUE is off, with SUNIQUE on it would be "STOU". Essentially it means that the ftp server at the other side signalled an error. Maybe you can have a look in the log files of the ftp server of the machine where you ftp to. Probab...

Maybe it's time to make a FAQ item for this question :wink: You cannot just read the "DataStage Log files" with vi e.g. you need something to get the log entries in readable format, either with dsjob or writing something in uv/BASIC to extract the entries. Also some third party add-on tool...