DSXchange

%CPU as reported by the monitor is usually wrong, for the same reasons that rows/sec is usually wrong. The clock is running even when rows are not being processed, and the time is rounded to whole seconds before the division has been done - %CPU is calculated as (CPU seconds) / (clock seconds) * 100...

Each instance needs a unique invocation ID. I suspect that you've run one instance with no invocation ID, and all the rest with the same invocation ID, which would result in one of them running and the remainder aborting because the job is already running. But do identify the real cause of the probl...

It would be more efficient to use a Sequential File stage, with the COPY command added to it as a Filter command. The Sequential File stage reads the output of the Filter command.

What worked? Did you leave it blank, enter the name of the current project, or enter the name of a different project? The third of these options carries certain intrinsic dangers - what if someone using the other project deletes the hashed file?

Source is either a Hashed File stage or UniVerse stage. Table name is RT_LOGnnn, where nnn is the job number from DS_JOBS. I assume you can use a Sequential File stage to create your delimited text file. Search the forum for the column definitions in RT_LOGnnn. You will need to create them in the Re...

Do you have write permission to the directory into which the extraction objects would be written?

The difference is how the table was created. Yours is one of the second kind. CREATE [TEMP]TABLE name1 (definition); CREATE [TEMP] TABLE name2 (definition) WITH NO LOG; When viewed through ODBC, Informix generates an informational message that you are using a "non logging" table. Ask...

Yes, by using sorted data and stage variables to remember the header information and count the detail items. What is the source? You may find it easier to extract 950 line items at a time for any one header than to try to do it in DataStage. For example the UNIX command split can divide a file into ...

If you can tell me how to generate an arbitrary number of rows out of a Transformer stage for each row in, I'd be happy to know it. There is a kluge where you use - typically - a routine to generate a long string with a line terminator between each generated "output row", and output that to a sequen...

APT_PM_PLAYER_MEMORY

It's a "rule of thumb" rather than a hard and fast rule. The hash table, in which every distinct combination of key values plus all calculated/counted output columns are stored, must fit in physical memory. If they won't, use Sort. If you're not sure, use Sort. With Sort, memory can be freed (and on...

Process data containing fewer distinct reference key values would be one way. Use more partitions would help too. Finding a different strategy, such as a sparse lookup or a Join or Merge stage might be another alternative. As you note, it is only an alert. You could create a message handler to demot...

You need a lot more knowledge about the way that the DataStage works in order to make any sense of these. In short, there are up to four separate shared memory segments, the so-called "disk" shared memory segment, in which lock tables and other "disk-related" structures are stored; a "printer" share...

4 not 14? The reason is already in original post: "brain's half dead". External filter stage that runs a shell script to iterate through the values is one way, if you're comfortable with scripting. Build stage to iterate through the values is another way, if you're comfortable with C++ coding. There...

When you import the table definition do the database name and table name work properly?

Is it expecting the owner name rather than the database name in this syntax? It's more usual to connect to the database, then specify owner.table (or schema.table, if you prefer) as the object being accessed.