DSXchange

Document all the possibilities, and the columns that need to be transferred in each case. The result should be a comprehensive target-from-source mapping document. The process of creating this document will clear your mind as to how to implement the ETL. I wasn't clear whether you have eleven source...

Only sometimes. If your design has two active stages directly linked (for instance two Transformer stages) they will be executed in one process. However, if you have inter-process row buffering enabled it will enforce execution of the adjacent active stages in separate processes. What you have calle...

Perhaps your /tmp file system has become full during the job run?

There is a module on routines in DataStage Essentials training class from IBM. Enrol soon. There also exists a class called Programming with DataStage BASIC but this is not regularly scheduled. Some vendors also offer custom training that includes a one-day introduction to writing DataStage server r...

No it won't. In a Transformer stage you can direct whatever columns you like to whatever output links you like.

Exactly the same size as the maximum file size that the operating system (possibly limited by the user's ulimit setting) can handle.

Your metadata describe a row that is longer than the first row in the file.

Only you can fix this. Either fix the metadata or fix the file.

DS.PLADMIN.CMD LIST PIDS Prepare_TCL_CLAIM_WCPAOP Cannot find any process numbers for stages in job Prepare_TCL_CLAIM_WCPAOP That was exactly the response I expected to get, since the job was not running at the time. That is, I did not get the same problem with the command that you did. I take it t...

Tell us what the log says about the first run and about the second run.
What is the status (exactly as reported) of the job sequence (not "sequencer") after the first abort?

Did you re-compile the job sequence after checking the "enable checkpoint" box - after all, it's a compiler option.

Looks like you have two instances of string constants with line terminators in them. Were you, for example, constructing beautifully formatted expressions? Not permitted - an expression must be all one line.

Is this a DataStage TX question or a server job question? That is, are you using a TX map or a Sequential File stage for reading the file?

Can you try the same task in a different (newly created) job?
Make sure that the table definition is precisely correct.

If it's dsdlockd it runs as dsdlockd.

It would be inappropriate of us to advise by guesswork.

If you can tell us exactly the identity of the daemon then we could advise appropriately.

Why not look through the startup script (which is also the shutdown script) to see how it is done there?

You may need to be alert for the order of elements in the incoming date to be able to specify Iconv() correctly. If you are sourcing the date string using an ODBC stage you can add the Date data element so that the input conversion is done for you.

It's probably the syntax. Where did you get it from? Try a dot rather than a space between LIST and PIDS

Surely, then, keeping it even more simple would be to use ExecSH as a before/after subroutine or to invoke the command from an Execute Command activity?