DSXchange

Iff you have been diligent with your metadata (loading imported table definitions into jobs and not editing them there) you can perform a Where Used analysis on the table definition in Designer.

"Iff" is mathematicians' shorthand for "if and only if". It is not a typo.

The client component is called Information Server Console. It's desktop shortcut icon has two orange blocks atop two grey blocks. This console is also the client for Information Services Director. It is NOT the same as Web Console for Information Server; not least because it is not opened in a brows...

There are effectively two strategies. Use a reject link from the Sequential File stage to capture the header and trailer rows, and process them appropriately in a separate stream (even in the same job). You can join the header/trailer information back to the detail information later if desired. Read...

OK, so you need to convert the space to a "-" and force six places in the fractional seconds piece. Try something like this: Convert(" ", "-", Field(InLink.TheTimestamp, ".", 1,1 ) : "." : Fmt(Field(InLink.TheTimestamp, ".", 2, 1), "L%...

There are four tiers (Client, Engine, Services, Metadata Repository). Topology is where (on which machines) you place these tiers.

What is the format of the timestamp returned by DB2?
Your expression seems fine to me.

You guess right. Try /opt/IBM/InformationServer/response.txt

What do you mean by "in use"? Most operating systems don't allow a file opened for writing (for example by DataStage) to be written to by any other process. Most operating systems implement NR1W (any number of readers OR one writer) locking on files. On that basis, if DataStage has the fil...

Did you set Round-Robin on both inputs?

There's no automatic way, but you could create a server routine and run it from the Routine editor's Test button.

Don't push.

Especially not on weekends.

So the index value is not really relevant - it's documentation only as far as a DataStage developer is concerned. If you bring in the multi-valued field as a vector, then the vector will have an integer index of some kind automatically in DataStage, though the first element of the vector is position...

Sorry, I was thinking of OCCURS DEPENDING ON.

If you remove the instance-related records from RT_STATUSnnn then the log events for that instance will automatically be purged.

Most of the ones I've seen have the value as a second-level (level 10 in this example) item.