DSXchange

The command is easy, "LIST.READU EVERY" but the output is complex to interpret. The best way to learn this is to download the UniVerse 10 documentation from the IBM website and locate the chapter describing the LIST.READU command. Then you will most likely have to cross reference and learn about the...

Is it "known problems and workarounds"? I couldn't find reference to it.

how about "orchadmin describe -s {dataset}"?

Are you certain that it is checkpointing that is slowing things down? If you turn it off does it actually much faster?

I think it is fixed - I see a working XML input stage at this 8.0 AIX site.

Does this happen with any and all datasets?

If Teradata sql doesn't allow this function you could try running the data through an aggregator to get the total, then use that result to compute the rank?

It takes a certain amount of experience to interpret the LIST.READU command output and it is not worth the time to do this. The damage you can do in a running environment with kill and UNLOCK using information gleaned from the LIST.READU and PORT.STATUS output is substantial. In additional to the kn...

Are you asking how to remove the warning message from the log or how to fix the 0-rows problem? For the first the answer is "message handlers", but without more information nobody here can answer the second.

Lol - I should have paid more attention I am fairly certain that I put this one in as eCase a couple of years back.

That is a known issue, and there is a current thread on the same topic.

Job parameters are not stored as such in the engine. The default values are stored within the job metadata, but the actual values used at runtime are only accessible by using the API routines such as DSGetParamInfo().

The system host name used during the DataStage install is stored and cannot be changed, but the underlying IP address can be changed.

If you remove all job activity and other stages, does the program behave differently and work? Also, did "reset" bring any additional information?

I'm not sure wheer that file could be coming from. You can use "fuser -fux {file}" to get the pids that have that file in use.

What database(s) are you using?