DSXchange

Yes, because DataStage still has to alert you about the possibility that your data may be truncated.

Could be worth it, because you get to work with heterogenous database environments- DB2/Teradata/etc. Only in theory. It's "marketing-speak". The version 7.5 class runs with DB2 UDB, yet makes the same claim. That said, they do supply quite good notes on the other main database types (Oracle, Infor...

This seems to be getting worse. I just did a couple of searches for combinations of words I know to exist. All "all terms" searches returned no hits, and "any word" searches only returned results for the current month, both when the days filter was left blank and when the days filter was set to 400....

So are you replacing these rows (there is "replace existing rows" rule), or are you deleting some and inserting different ones, or a mixture of both? That is, do you only delete rows where that row (set of key values) is in the input stream, or do you delete these rows irrespective of what's in the ...

Create one job to do the deletes and one job to do the inserts. Run the second after the first, to avoid locking issues. For large volumes of data stage the rows in a Data Set.

When Write Method is Load you are not doing transctional inserts. You are using sqlldr. Therefore transaction size is irrelevant.

Likewise the performance monitor is a Java app, but there should be no way that it could cause jobs to abort. That's the theory anyway. In practice jobs can abort through not being able to communicate with the performance monitor.

Go ahead and delete them. I assume you can identify them. Beware that transactional deletes can be very slow. You can delete them in a Before SQL command, through a script in a before-job subroutine, or in a preliminary job. the choice would really depend on what comes next and what stage type you'r...

Why not use a server job? After all, it's only one row. A server job will be far more efficient than a parallel job for processing one row. And you can set the user status area much more easily.

Not if it doesn't need one. All 7.5.x versions (7.5.1 through 7.5.3 but excluding 7.5x2 which is a special case) use the same installation method.

What do you know about operating system monitoring? Sys is the CPU time charged to "the system" (for example for process initiation, paging, etc); User is the CPU time charged to the actual executing user.

No. Somewhere it must keep track. Otherwise there's no way to establish the restart point.

The string for a decimal needs to have at least two more character positions than the precision of the decimal data type, one for the decimal placeholder character and one for the sign character (which may be a space). When converting from an unbounded string to a bounded string (for example string ...

What do you mean by "did not work"?

It may be that there has to be some statement there. I use an additional WHERE clause, such as DELETE FROM TABLE WHERE 1=0. Oracle is quite happy to delete the 0 rows that match my condition.

I wouldn't think it's possible, not least because DB2INSTANCE can only have one value at a time.