DSXchange

Search DSXchange for information about the UNLOCK command.

You are going to have to work out what is different between the two environments. Clearly something is.

Welcome aboard.

This is most easily done using a routine that invokes functions from the DataStage API.

You don't want to run 40 jobs at the same time - it will overload your machine (unless, of course, you are on a version in which Workload Manager is enabled - that you're in version 8.x suggests that you don't have WLM). Let's imagine you want to run no more than eight jobs at a time (and even that ...

These libraries are used by ISA Lite. I don't know by what else, so would second the advice to involve support.

Do you really think this is a suitable job for an ETL tool?

Surely the email server itself can be scripted to perform this task.

That said, yes it is possible with DataStage, probably easiest using a sequence job.

Yes it is possible but you are right, you would need at least two engine tier machines (with concomitant PVU implications). When you license QualityStage alone, you get more than 50% of DataStage anyway. All the components that QualityStage and DataStage share. When you license DataStage alone you g...

Presumably the file name, or part of it, is parameterised. Examine the job log to ensure that the parameter value is being passed correctly from the dsjob command. Make sure, too, that you're comparing apples with apples; that both jobs are processing the same file. Verify how null handling is confi...

Add an entry for dsadm in both cron.allow and at.allow, as already mentioned.

Are you loading it using the tool or typing it in manually? If the latter are you surrounding it with sharp signs?

Column analysis should not use any indexes; basically it issues the query SELECT * FROM tablename against the database (or just the specified columns if relevant). Sampling is performed within Information Analyzer. The only time indexing might be useful is a virtual table in Information Analyzer tha...

Yes.

The same way - by reference to the upstream activity variable $Counter.

Using stage variables would be ideal. See if you can work it out. If not, show us what you tried, and what results were produced.

Take a look at the USPREP rule set, and adapt a copy of it to your needs.