DSXchange

Can you please post that part of the generated osh that pertains to the Aggregator stage, between the lines of asterisks, so we can check your work? Thanks Ray for an instant reply but the job log is too huge to put in this forum... I am posting few of the lines before and after that error here Cop...

Situation: I have 3 int. columns and 1 amt. decimal(16,5) column. Pty_Id, Stm_No, Doc_No and Amt. I am taking a count of records and a sum based on those 3 int. column grouping keys. Output is a fixed-width text file with all cols. as char. Pty_Id, Stm_No, Doc_No, Rec_Count and Tot_Amt Error: Aggr_F...

We had to bounce the datastage server for the new ulimits to take effect.

Thanks Ray. Our PXEngine was symbolically linked to ./PXEngine.7501.3/bin. This ldedit solution fixed our problem.

Okay ...i am trying to make sense of what i have read here. Please help me along. The original values for the 4 memory segments in uvconfig are - DMEM = 0x40000000 PMEM = 0x50000000 CMEM = 0x60000000 NMEM = 0x70000000 So Ray, what you are saying is that simply by changing DMEM to 0x90000000 and PMEM...

hi ! I am facing the same problem. I was trying to use the ldedit solution by fridge but i can't figure out the fullpath to "osh". "which osh" returns not found I tried "find" and this is what i get - /u01/app/product/dsadm/Ascential/DataStage> find . -name osh* -print ...

Ray, I am thrilled that you are answering this post. Now may be we can get to the bottom of this issue. I am still a novice and would really appreciate your help. Let me explain the setup to you again. On our dev server "dsadm" is the datastage admin ID. We have three projects DEV, UT and ...

$HOME is always set by the dsenv script and is the same as the home directory of dsadm or whatever the admin id is. To over-ride it declare a user defined HOME param in DSParams file in the project directory.

Hi I need to know who/what sets the $HOME parameter in unix shells spawned by a datastage job. I have a datastage job that invokes a unix shell script as an after job process. In our setup, "dsadm" is the datastage admin ID and we use a datastage user id of "pbatch". The datastag...