DSXchange

Hashed file read and write cache sizes are viewable in the Administrator client, project properties, Tunable tab.

Not quite yet ready to reinstall. If you create a copy of the job can you open the Sequential File stage in the copied job?

What else has happened on the client machine? Has any new software - ANY new software - been installed? Has any software been removed?

This is unusual behaviour and, being asymptomatic, difficult to diagnose.

The quick fix may be to re-install the DataStage client.

I am preparing some papers for the IOD conferences (in Rome in May and in Las Vegas in October) on QualityStage Rule Sets. I'd like to have a single slide with a list of the various kinds of classifiable data for which folks (that's YOU folks!) have built Rule Sets. All contributions are welcome. So...

In short, no. You can certainly inspect the object code using a hex editor, but this is DataStage BASIC and uses completely idiosyncratic op-codes which aren't documented anywhere. You can use VLIST command to simulate an assembler-like representation of the object code, but I really don't think tha...

Is the DB2INSTANCE environment variable correctly set for the process under which user ID the job runs? Check in the "environment variables" entry in the job log.

The input was VarChar. It was the easiest - and probably best - solution.

OCI = Oracle Client Interface. Effectively, it is the Oracle client software that must be installed on your DataStage server. As far as Oracle is concerned, a DataStage job is just another client application. For server jobs there is a stage called OCI, which invokes the client interface directly. T...

Warnings is not the same as failure (you can research this statement on DSXchange).

You will need Success and Otherwise triggers on the five activities leading to an Any sequencer then on through a stream of activities that ends with a Terminator to shut things down.

Use substring operators to decompose the string into components (in stage variables to make it easier to understand), and If..Then..Else to adjust the hours to 24-hour clock, and then concatenate all the components to form the desired timestamp. If you have single-digit quantities you may need to ad...

Enabling multi-instance makes a difference in how the job is compiled, which allows DataStage to invoke the runtime engine with a job name including a dot. (Even when you start a multi-instance job with no invocation ID the dot is still there.) It remains true that a job with an identical name to an...

Do stop thinking of it as UniVerse. DataStage ceased being UniVerse in version 6.0. Prefer dssh as the command to enter the DataStage shell. Otherwise the story is the same. But if you ever work in a site where UniVerse and DataStage are both installed, the difference is critical. And they ARE diffe...

Search DSXchange for OpenSequentialFile, in which there is an example.

dsjob -logsum

Why not have S0 control both S1 and S2?