DSXchange

add a before or after job subroutine call to any job which does a ExecSh of "umask" and report what is written to the log file.

By "Job Control" do you mean you have a server job and call up the functions in the "Job Control" section? If so, did you really perform correct error checking in that hand-written code? Do you have a sample or sample output?

You have run out of disk space in the sendmail. I am not sure which one is used, but the first place to check would be /tmp. Run a "df -k" command and see which ones are 100% full.

What is column XYZ declared as and shoul it be at position 316 in the row? You could use your favorite editor which supports binary to look at positions 316 to 319 and check the binary values.

You should also take into account the size of buffering between stages used (if your target is significantly slower than your source) as well as repartitioning, sorts (both implicit and explicit) and space used in lookups.

Can you supply more information? Does this happen on all jobs on this machine, or just this job? Does it happen every time?

There is a reason why the /tmp directory was referred to - the score is dynamically generated at runtime.

Well, there are elements of truth in the statement, i.e. that parts of the repository that used to be in DataStage hashed file are now also in the database repository, but there will still be a a directory structure on UNIX.

You need to use the isvalid function with a date and a format string. Note that you cannot detected whether 2009-03-01 is YYYY-MM-DD or YYYY-DD-MM format.

I checked my documentation and did not find a single reference to either physmem or virtmem, which is why I asked where you had the information that they are syntactically valid for a configuration file.

Umm, then that is your error. You either need a "/tmp" directory (are you sure you don't have one?) or you need to change your DSParams and APT_CONFIG files to reflect that. Remember on Windows that it might be C:\TMP.

Is the file still there after the program run? If yes, what are the attributes and does the user you use to run DataStage jobs have appropriate delete rights to the file?

I haven't worked with IXF files and DataStage. Don't you also need to build a script load file in addition to the IXF data file?

If the project was successfully created in the Administrator the the UNIX directory structure will have been populated. Unless you can explain the problem in more detail it will be difficult to help solve your problem.

Please do not post the same question twice in DSXchange. The answer has already been given in your other thread with the same topic. It is "yes", use the CFF stage.