DSXchange

The best help youre going to get will be from an Oracle DBA, who can inspect your stored procedure, decode those error codes (which you could do with the oerr command) and recommend how to correct the situation. Since we can not see the definition of your Stored Procedure our diagnostic possibilitie...

Add project is only available to the designated DataStage administrator ID. If you have designated dsadm that's the end of the story: there is no scope to add a second DataStage administrator (until you get to version 8.0). Of course, root can still do anything.

Since PeopleSoft don't deliver parallel jobs (as far as I know), the response belongs in this forum.

Fine, go right ahead.

I'd be happy to do Craig's step (2) but you would need to pay both my consulting fee and also the cost of the silver platter.

How much physical memory is in your DataStage server machine?

ACE is the "itag" for UniVerse - and therefore for DataStage prior to version 6.0. Have you had DataStage since an earlier version? ADE is the default "itag" for DataStage at version 6.0 and later. An "-itag" install allows you to select a different "itag" (instance tag). ADEBnnnn is the key of the ...

It will be no consolation that some things DSXchange don't work properly in Internet Explorer either - for example really rough graphics for premium posts (compared with Firefox). Clearly (since Firefox is OK) this is a browser issue, or one of support for browsers in the underlying PHP code. I beli...

You may be using 7.5.2 now, but your site has had DataStage for many years, and there may be some "leftovers" from previous version practice. Inspect the SHM.TO.LOAD file on the system that is working. You will see that each routine is represented by its account (project), directory file name and pr...

It is certainly possible to use job parameters as you have indicated. Beware, however, that the "$" character should only be used for those job parameters that were added to the job as environment variables. "Ordinary" job parameters do not have a leading "$" character in their names.

Tell us what you are trying to do when these problems occur. Also, please post the exact error message - copy/paste rather than transcribe - we don't need the message filtered through your limited understanding of what may be happening.

Management also needs to put "hire administrator" on the project plan.

Welcome aboard. The configuration file you posted contains only one node name, so that all your jobs will run without parallelism. To run parallel a configuration file requires more than one node name. For example: /* Two node configuration file sharing resource and scratch disks. */ /* (Best pr...

Check your job thoroughly. Make sure there are column definitions for every link in the job.

Funny, I hadn't noticed that U had responded.

The correct English spelling of the second person personal pronoun is "you".