DSXchange

Please post the EXACT error messages you are getting (copy and paste). Meantime you might also search the forum for "signal" and "SIGSEGV".

Wow, 14570 items in your command history! Don't you ever log out?!!

Surely awk is a bit over the top? Why not just wc -l pathname as the command/parameter combination?

You may need to be careful with PATH. ProfileStage uses its own Perl command line interpreter (from memory PerlCRT.dll) but other systems (such as Oracle) use something else (Perl58.dll in the case of Oracle). You must make sure that the process ID under which you start Message Switch and Analysis S...

You could use a UV stage to do a non-key lookup from the hashed file, but it would be slow. More efficient would be a routine, with the "lookup table" as searchable structure in COMMON memory. Do you need to be able to recreate the obfuscated data values? That will add the need to record the actual ...

Otherwise search the forum for BCI which is a BASIC-callable library of functions that mimic the ODBC API.

So, let me get this clear, you want me to perform precisely the same search on the IBM website that you could perform? Is that right? Would you like to know my hourly rate for "consultancy" services?

There is no log. You need to take snapshots using netstat or, perhaps, list_readu | grep :

I'm guessing you want to spot the culprit. The list_readu report will show the identity of the client machine as well as the pid of the dsapi_slave process.

That's not what I asked for. Please post the expression that generates the "list of things" processed by the loop. It's a property of the Start Loop activity.

Something you've tried to do from a DataStage client (through a dsapi_slave process on the server) has hit this limit. Keep the core file in case you need to report the problem to support.

Backslash

The BASIC Transformer stage requires the presence of DataStage server software. In an SMP environment (share everything) this is not a problem, but in an MPP environment there will be issues unless DataStage server software is installed on every machine. Can I be your sales rep?!!

Use a Compare stage; as well as the result you get each source row as a single column subrecord (you can promote these later with Promote Subrecord stages).

Is there a link from your End Loop activity back to your Start Loop activity? Can you please post your loop-generating expression from the Start Loop activity?

Read the messages carefully. There is a limit of 100000 bytes currently in force. To read more than that you will need to change something. Can you post the record schema associated with the Sequential File stage's output link?