DSXchange

The names are spelled differently in the two files. Is it DB2_SEMATST or DB2_SEMSTST ?

I don't think there's anything in DataStage (obviously you can demote or suppress the warning with a message handler). Is there an environment variable for the database server that prevents generation of this particular message?

7.5.2 or 7.5x2 ?

Only by reading the job log, either with a routine or a command. In the routine, use DSGetNewestLogId() to determine the most recent Fatal error(s) and DSGetLogEvent() to retrieve the detail of that event.

What do you mean by "surrogate file"? Is this a state file?

This is the first time you have reported success from UV_SCHEMA and UV.ACCOUNT. It was necessary to wait for that confirmation, and eliminate that possibility, before looking further. Queries are read-only, and do not affect (change) anything, particularly not other projects. You must now turn to th...

As a general rule you are correct.

Use "automatically handle activities that fail" in all sequences or send your Failure triggers to a Routine activity that invokes UtilityFatalToLog.

A preparatory question - what is "performance" in an ETL context?

The limit is one set in DB2, not one set in DataStage. Discuss with your DBA about increasing the limits, and/or try to create a query that uses fewer resources.

What are you doing with the result of the join? I daresay that's where the slowness is arising. Create a job that performs the joins and sents the result through a Transformer stage to a sequential file. Add the constraint @FALSE to the Transformer stage output link. Run this job. How long does it t...

Welcome aboard. :D Etiquette Note We do not do "ASAP" or "urgent". DSXchange is an all-volunteer site whose participants post as and when they can, and usually only if they have something useful to contribute. If you need urgent help, sign up with your support provider for priority service, and lear...

In that case you probably need
WHERE LKP_DD_015_03_S_PROD_INT.T1_ROW_ID = :3

Is DataStage executing from the same user ID that you used in UNIX?

creates a pointer to the UV.ACCOUNT table, which pointer does not exist in your project by default.