DSXchange

Which patch and have you examined the patch log file(s) to see if they have any errors?

In a Transform stage, you can use a derivation of "GetEnvironment('USER')"

At the moment I can't think of a quicker way. If you run the job, then do a "ls -ltr" on the &PH& directory and choose just the recent files you should be OK as well.

are you certain that your separators are actually "TAB"s and not "SPACE"s?

If you don't have many users on your system, go to the project directory and then into the "&PH&" subdirectory there and delete all of the files (these are output files from the background process output to stdout and stderr). Then re-run your job and after it aborts look at any and all file...

Are the DB2 stages visible in your designer palette? Also, if you edit the jobs what do the icons look like and can you open the stages?

If you reset the job do you get a log entry "from previous run..." and if so, what does it contain?

You can specify "default values" in your column definitions, or you can explicitly convert nulls in a transform stage.
Right-mouse-click on the column in the source stage and choose "edit row" to get the box where you can edit the values.

With what error message did your job abort?

Probably you are using a CHAR instead of VARCHAR column in your definitions.

Are you using "view Data" to see the data or another tool?

It might have been written by them, but this shell script is not part of the standard install. I've just checked 4 of our systems here.

It is complicated to find out which locks to remove. My preference is to enable the deadlock daemon and just wait for it to clean up things once the client session is gone. The UNLOCK command doesn't trigger any internal processes, it goes to the shared memory which is used for lock management and c...

Except the "DSEClearSockets.sh" script is one that doesn't belong to the product but is user-written.

mmanes - the commands are correct, but don't help much in this case. The device/inode numbers as well as the "user no" (not the pid) can be retrieved using the "LIST.READU EVERY" command and the user needs administrator rights in order to execute the commands.