DSXchange

Look in the Administrator's manual.

It will skip any prior activities that were checkpointed because they finished successfully. This is all clearly explained in the manual and the on-line help. Were you to search the forum you would also find the explanation.

Search the forum for the text in your error messages, particularly the ones with "E" codes.

No. Only you can.
WHY do you have "so many job activities"? Aim for a more modular approach with simpler modules.
You can go throught the job log for the job sequence looking at the "job run requested" events which will reveal the parameter values being passed.

I think the derivations of StgDosPri stage variable may be the issue here - they are generating logical values. The best way I can illustrate this is by rearranging its derivation expression. IF ToTrans.eoynpt=0 THEN ('0' AND StgStdPri=0) ELSE (ToTrans.dosnpt AND StgStdPri=ToTrans.eoynpt) Now, what ...

... but if you're in a routine, you can execute it via a call to DSExecute. And you can adapt the SQL. SELECT JOBTYPE FROM DS_JOBS WHERE NAME = '<<Job Name>>'; If you really want the most efficient approach your routine could read from the DS_JOBS table (hashed file) directly, bypassing the query en...

You might also like to check out EtlStats, on Kim Duke's web site.

Welcome aboard.

We encourage folks to Search the forum before asking questions, in case the question has been asked before. Yours definitely has. And we're not all that keen on answering the same question many times.

Begin work.

VERIFY.SQL used properly should re-synchronize all the system tables in the DataStage/SQL Catalog.

Etiquette Note
When a thread is marked as Resolved convention requires that a post is made indicating how it was resolved.

I suspect in this case that the default Lookup Failed rule (Fail) was changed to Continue, Drop or Output. But I don't know for sure.

Does your approach work? Be happy. Moderate your expectations; to aggregate a large number of records (which is necessary in your requirement) takes system resources. About the only suggestion I have is to sort your data by the grouping columns and preserve that sorting with Sort stages specifying "...

It's not really clear that this is the source of the problem. To isolate the location can you please run with operator combination disabled in the Transformer stage or in the job?

Scrutinize your lookup table (LUT) design. Does it REALLY need all those columns? Each row is currently about 3KB, which is a lot. Does it REALLY need all those rows? Can you populate something smaller? When it is said that the LUT must fit in memory, this really does mean in memory. Can you add mor...

More information is required. Including: Why do you "shout" (bad netiquette, definitely bad in a professional forum)? Where did you learn to spell? (I'd be seeking a refund.) Are you aware that Cleanup Resources does not pick up locks held by defunct processes? How does one identify "all processes f...

Have you tried? Any answer we could give would be at best a guess. Theoretically what you want to do is feasible, but not via the mechanism you are suggesting. You would need to reinstall the server then use VERIFY.SQL to update the system tables with the location of each project.