DSXchange

a) did you setup the Websphere console? If "yes", then what is your error message when trying to use the admin tool?

There are various forms of "binary" and unless you know what type it is you won't be able to convert it. Is your source EBCDIC that you need to convert? Or is it packed decimal data?

It is like asking which is the better vehicle - a Porsche or a Chevy van. The answer will depend upon what you want to do with it. Fixed width files are great for parallel processing (finding the 100th line is a simple matter of mutiplying line length times rows). This quick direct access is not pos...

The domain will be "your.Datastage.machine:9080" but you will need to have a project to connect to. Can you log into your DataStage administrator? Did you perform the setup actions in the Websphere web client?

With Version 8 you use the Websphere frontend for managing users, with a couple of mouse-clicks you can revoke privileges from users.

Wow - that was fast work indeed!

This is a difficult one to answer from DataStage. You should start at the other end, namely from your chosen program used to send mail on Windows. Once you can send a mail with attachments from the DOS command line, implementing it into DataStage should be easy. Which mail program are you using on W...

This would not work with a before-job subroutine. The correct way to implement this is to use a job sequence where you execute your external command(s) and then pass the results to the job as parameters; those can then be used in your transform stage.

Try running your job with a 1-node configuration and then with a 2-node configuration. If the results are different, then you have a partitioning problem that you need to correct.

I think your best bet would be to export a job with old, then make the changes and export the job again and run a "diff" on the two .dsx files. Then export all of the jobs into a .dsx file and perform a global replace on it and re-import the jobs.

The 32766 limit is UNIX one; the inode/entry table for a directory is limited to this number of files. When this happened at a customer site with lots of jobs, I did a quickie fix of resizing all the RT_STATUSnnn files from dynamic to static files. The better solution is to "calve" a new p...

I was referring to the insert array size earlier, as you have noted those are the only options given for Oracle.

You can explicitly set the value on INSERTs, but with UPSERTs the two ENVironment variables apply:

APT_ORAUPSERT_COMMIT_ROW_INTERVAL
APT_ORAUPSERT_COMMIT_TIME_INTERVAL

But if it were a PX installation and a valid dataset, then the answer is "yes"

With Version 8 you can use the Websphere console to specify which userid is actually used - did you check that userid's access rights to the directory or those of your UNIX user? It does look like a permissions issue.