DSXchange

Tune the control file. Don't use the Bulk Loader stage type at all - use a Sequential File stage and only create the DAT file(s). Add hints to the control file, for example for parallel load. Add appropriate buffer sizes to each column, rather than use the default 256-byte buffers. I have reduced a ...

Change the data type for output from Char(2000) to VarChar(2000) and apply a TrimB() function.

What stage type are you using to apply Max() ? Given that the field is string[10], you should be able to use an Aggregator stage.

I've also had that happen on DB2. The reported symptom also gives you the fix; you need more room for transaction logging.

If you're going to allow BASIC Transformer stage, then the ideal function is

The issues log should be busiest in the "dev -> test -> back to dev" cycle. That way you should get ETL as bulletproof as possible into the production environment. Of course, whoever does the testing needs to be sufficiently astute, cynical and painstaking. Handling of failures in the ETL itself - f...

Open the table definition in Manager.
Select the Layout tab.
Choose the Parallel option.
Copy the schema, paste into any text editor.
Save schema file.

Does that work in parallel jobs?

Oconv() is not available in parallel jobs, except in BASIC Transformer stage.

I shun the expression builder, so won't have seen this. I've certainly used the /*+ APPEND */ hint to good effect here and there (but still prefer sqlldr).

This is actually quite a complex topic. The sizes of the lock tables are, as you guess, configurable. There are, however, a number of these tables; file locks, group latches, readu locks, readL locks, waiters. The best reference is Administering UniVerse which you can download from IBM's web site

What exactly do you mean be an "integered" column? Integer data types can automatically be promoted to decimal, provided the decimal data type has sufficient precision. For example, the largest legal (four byte) integer has ten digits; therefore, to be able to guarantee that the decimal column can a...

The thing to remember here is that a job sequence is just a special case of a server job.

The only thing special about it is that it consists of (read-only) job control code generated by precompiling its design.

And why jobs are added int DS Designer ? Can I block this ? You should only see these in Designer if you open the VERSION project in Designer, which is not what you should be doing. In regular projects the only indication that a component has been versioned is that it has some extra text in its lon...

With the lookup stage you have four alternatives about how you want to handle the situation when the lookup fails. Click on the tool in the toolbar that seems to have a small piece of chain on it. This gives you access to the rules for "condition to perform lookup not met" and "lookup failed". Each ...