DSXchange

Is NLS enabled on this Job? If "YES" IsNull will not work for UStrings. Make sure that Date field is not Ustring. Is that fact (that IsNull() does not work for ustring when NLS is enabled) documented anywhere? As far as I was aware, IsNull() should work with any data type, whether or not NLS is ena...

But it can't call a parallel routine.

dsjob.exe on UNIX ??

What you've actually got is the cleaner of the two approaches. You can bring all four reference links out of the same Hashed File stage. You can enable link public cache or even system cache for the hashed file. The nice thing about this approach is you can tell exactly which piece of the puzzle is ...

Use the UNIX command ls -l hashedfilepath to report the size of DATA.30 and OVER.30. I would have expected different error messages if you'd corrupted the hashed file. Can you write other records to it? Perhaps the key value you've supplied contains a non-printable "mark character": these are not pe...

The maximum length for a job name by default is 768 bytes. This is because the job name is the key to the hashed file DS_JOBS. The maximum job name length is set by the MAXKEYLENGTH tunable in the uvconfig file. In current versions this is set to 768 by default. It can be increased to 2048, but ther...

If multiple jobs read the same parameter file using the same routine, only the one that actually owns the lock is reading it at any time. The others are queueing waiting for the lock to be released. There may be some sleep time involved in this, depending on how your particular operating system impl...

You find the corresponding value in the input stream, and put that column name in the reference key expression field.

Address DE in the object code is associated with the source statement GET.Pin%%V0S1P5 which (from source line 33) maps to a GET (get next row) call on the main input link into the stage (link name zoph_arde_out) and which, from line 112, is a call to $DSP.GetNext. My main reason for wanting to see t...

We need something from further down the "big log" - specifically what's happing at and around address DE.

That would be with a symbolic link (on UNIX, created with an ln command). On a Windows server you could use a "shortcut" - which really means the same thing.

Yes, but you want to see whether it EXISTS, so it should point to itself. The value from the input stream is then mapped onto this column via the reference key expression.

This is usually a symptom of machine overload. What else is happening on the machine? For example, is it a domain controller as well? Those kinds of activities run at a higher priority than all other processes.

Please post the output of the following command, executed at TCL: