DSXchange

Start by getting your DBA to tell you what an error code -302 is in DB2.

It's hashed file, not "hash" file. A hash file is a tool for reducing the size of a block of hash. 1. What is the maximum size of a hash file that can still give a good performance? Lets assume we have 2 to 3 fields, each of length < 10 and integer/varchar type. It depends on the operating system. U...

The answer to this question is completely documented at the end of Chapter 2 in the Parallel Job Developer's Guide (qv)

Or use a job parameter?

Custom SQL means that you write the SQL. It must have exactly the columns in its SELECT clause as you have columns in your Columns grid in the stage. Apart from that restriction it can be any SQL statement that is legal for the database and which returns rows containing those columns.

Flat files are very fast. Extract to staging area can be run in a convenient time window for extraction. Decoupling means that you don't have to do the load phase at the same time; it can be run at a convenient time for the target database. Some folks, with complex transformation/cleansing requireme...

Did you even look at the DataStage log (via Director)? My first question would be why so much stuff is being logged; in an ideal world there should be only a few tens of entries per run, and no warnings at all. Is auto-purge disabled, so that the log grows indefinitely? If so, manually purge the log...

You can't perform any kind of lookup without a reference key.

Another possibility is that the job was created and compiled by someone else whose umask setting and group membership was such that you don't have permission to open the RT_STATUS538 file.

This is less likely, but may need to be considered as a possibility.

My guess would be a corrupted RT_STATUS538 file.
You could try clearing the status file then recompiling the job.

Find a list of the active stage names in a job with DSGetJobInfo() and find the stage name you require in that list. Find a list of the links connected to that stage using DSGetStageInfo() and find the link name that you require in that list. Use DSGetLinkInfo() to determine the link row count. Alte...

If you've committed you can't rollback. Databases 101.

You have to "unwind", by deleting. Based on job start timestamp is OK for rows newly inserted but not for undoing change. That's why type 2 SCD is a good approach; you never update rows (except maybe with expiry information).

If it's a memory leak I'd expect to see a segmentation violation (or SIGBUS) error somewhere. Please post their response. I'm curious.

Is this a literal string "%3D" or are you referring to a single character 0x3d ? Convert() is a character-by-character conversion; Convert('%3D',':',Arg) is the same as Convert('%',':',Arg) then Convert('3','',Arg) then Convert('D','',Arg) - which is not the effect you intended. In server jobs and B...

No. You've found the appropriate technique. The Aggregator derivations do not support the use of job parameter references.