DSXchange

Just thinking aloud, but could this translation be done using a custom NLS map?

katz

The underlying problem with the TZ environment variable was resolved by restarting the cron daemon. The work-around assignment made in dsenv file can now be removed, and there are no more incidents of jobs hanging on the DSWaitForJob.

The above technique works a treat! Thanks again ArndW for your suggestion.

katz

Hi ArndW,

This is an approach worth investigating. Thank you for sharing this good idea. I will do some testing and let you know I get on.

katz

Hi Craig, The After-job routine captures audit information regarding the server job it is called from. The following information is extracted in the routine: Job JOB_NAME JOB_DESCRIPTION JOB_STATUS JOB_WAVE_NO JOB_START_DT JOB_END_DT JOB_ELAPSED_SECS JOB_BATCH_NO JOB_VERSION_NO JOB_PID Parameters PA...

Yes, the monitor shows that all the stages have completed. There have been a couple of cases where the DSWaitForJob executed in an After Job Routine was the one that "randomly" failed to detect when the called job was finished. But the problem has equally occurred in jobs that do not use a...

Thanks Craig - its nice to know that my effort to be clear is appreciated. However, when reading your post I've noticed that I've posted in the incorrect forum.

katz

If you're on UNIX, then you can start multiple concurrent readers of the same input csv file; one reader for each output file you want (e.g. 4). Use AWK to filter the set of rows in each reader based on the modulus of the input row, setting the filter in each reader for a different modulus value. Fo...

There might be a source system log/journal file from which you can extract the incremental set of source data. Updating the target without key definitions is a bit harder to do.

An alternative to running multi-instance jobs in parallel for separate input files could be to start multiple readers of the same source file in the same job (the source is a sequential file?) and use awk as a filter to to read a subset of rows from the single input file. Awk is available for window...

Hi,

IBM Support have replied that the password details are encrypted. That seems to have satisfied my questioner, for now.

Thanks, for your quick replies.

katz,

Hi Ultra,

You are correct that encryption should be handled in the Presentaion Layer (one below the Application Layer) of the OSI model.

katz

Hi DSguru2B, Thanks. This was more or less my response (the encryption should be handled in another layer of the stack - in this case TCP/IP). Never-the-less, I am being asked to find out if the clients encrypt not only the password, but also the Server name, User Name, and Project. I do not see thi...

Hi,

I am asked by a colleague if the DataStage clients encrypt the login credentials when sent from the client to host. Does anyone know? (We are running client version 7.5.1.A.)

Thanks,
katz

Thanks Ray,

That is a certainly lot more elegant. It even seems to run faster. A clear improvement. I've not worked with the TRANS or XLATE functions until now; it seems like a bit of a play-about is in order.

katz