DSXchange

My guess is that the secure shell (secshd.exe) is overriding any idle non-timeout request you may have issued.

Of course, DataStage BASIC is a powerful enough language that you could modify the code. But how would you then compile it?!!

31538

No, you don't need to do anything with the code. You copy parameter settings into the Job Activity objects (in DS_JOBOBJECTS) and require that the job sequence be compiled subsequently.

Firewall blocking dsrpc port?

At at least one of my client sites I crafted a routine to load parameter values into a job sequence from a standard set. It should not be a long stretch to load from these into Job Activities.

Hmm... would this be reinventing the wheel? Can Parameter Manager already do this?

The host name specified is not valid, or the host is not responding. In particular, code 81011 decodes as "unknown host". Make sure that the hostname you've entered can be translated to its IP address on your client machine. Maybe try the IP address instead of a host name in the connection dialog? ...

You can always force a refresh from the View menu, or Ctrl-R.

Transforms are pre-stored expressions. They are not callable. If you use them in Transformer stages then inspect the generated code, you will see that they are replaced by their defining expression; that is, the expression becomes in-line code. It follows that the response suggesting DEFFUN is way o...

Welcome aboard! :D Under what user ID do your DataStage jobs run? Check that this user has all required permissions. A good way to find out is to run a job that contains ExecTCL as a before-job (or after-job) subroutine, it really doesn't matter. In the Input Values field specify the command SH -c i...

That you can connect via sqlplus does not necessarily mean that there is no error while trying to retrieve text from Oracle system tables.

Transaction isolation level is a concept originally introduced as part of the ODBC standard, by Microsoft. The ultimate reference, therefore, is the ODBC 3.0 API Programmer's Reference and SDK, from Microsoft Press.

How many processing nodes? If more than one, what partitioning did you use? Was the Oracle Enterprise stage trying to SELECT in parallel? Any warnings logged? Have you tried forcing the Oracle Enterprise stage to execute in sequential mode (as a diagnostic technique only!)?

There is an undocumented flag [suppress zero] available in the Modify stage. Read about it here.

Two possibilities. You (or someone) has probably imposed manual override of purge parameters for this job. When you open Job > Clear Log in Director, does it indicate that auto-purge is enabled for this job? You are mistaking the fact that log entries are filtered with "disappearing". By default you...