DSXchange

I disagree with the assertion about "most" important. I believe that prevention is better than cure.

Yes it is. The second "}" character is the clue. So, yes, it is badly named - it defines only one node.

Use the $UserStatus activity variable from the Job activity that invoked the "JCL job". Not really sure what you mean by JCL here - it's usually a mainframe term.

I have no experience with this combination. But remember that the customer (a) is always right and (b) having been professionally advised bears responsibility for any decisions. Have them sign a document confirming that they have decided to act against your professional advice and indemnifying you f...

What value did you set for maximum sessions when the software was installed? (You can check the response file to find out.)

A state file must generate unique numbers, no matter how many processes are reading it. So if 100 occurs in one job you should not expect 100 to appear in any other job reading the same state file.
Why would you believe otherwise?

Welcome aboard.

Why "without the Transformer stage"? It's the right stage for this job. And there's no other stage out of the box that can perform that task.

Make sure, too, that you don't use reserved words as variable names.

An internet search, particularly of the IBM website, will answer this question. Business Glossary is one of the suite of tools that make up IBM InfoSphere Information Server. The purpose of Business Glossary is to store - and make available across the suite and, perhaps, anywhere - business terms al...

Have your DBA track the actual query that was received by Oracle in this session. Your syntax is valid, assuming that a column or synonym called A exists and is a DATE data type.

Does it work if you use HH24 for the hour component in the date picture?

It's far more complex than you imagine. To find out all the steps you need to take, first enable server side tracing (which you can do with the Administrator client or from TCL) and then effect a "number of runs" log purge from Director. Disable server side tracing then inspect the trace f...

Did you install the supported C++ compiler before installing Information Server?

When's the interview?

Why not Transformer stage? It's the ideal tool for the job.

Of course, it can be done with other stage types - Build stage and External Filter stage, but it's likely that neither of these will be as efficient as the Transformer stage.

Maybe you're looking at the wrong column as your culprit? Try removing that column from the job (purely as a test).

There's nothing out of the box for you. You might Search DSXchange for examples of how to go about automating this task - essentially a routine that runs through all jobs changing their purge settings. The auto-purge settings only affect subsequently-created jobs.