We've a fresh DataStage v8.1.0.1 (Server Edition) installation on AIX v6. Jobs are exported from Windows Server 2003. After moving to the AIX environment, all imported jobs are working fine except for those which contains Aggregator stage.
After reading around 8 million records from the data source's table (the whole table volume is 9 million records), the job aborted and logs the following error after reset at Director:
From previous run
DataStage Job 65 Phantom 20574
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.WriteLog at address 20
Job design is as follows:
Code: Select all
DRS stage\Read --> Aggregator --> Transformer --> DRS stage\Write
And here're our troubleshooting trials:
1- After putting a Sort stage before the Aggregator stage, the job worked fine.
2- When grouping by 2 or 3 columns only, the job worked fine.
We thought after these trials, that it's a memory issue but the server has 16 GBs RAM! So, we swithched the datastage user which runs the jobs from 'dsadm' to be 'root' to ensure that there's no memory allocation limit for that user and job still aborts.
Another observation has been noticed at another job:
Code: Select all
DRS stage\Read --> Transformer --> DRS stage\Write
I still think it's a memory issue after troubleshooting trials but there's something still misssing.
Any help will be appreciated and sorry for long post.
P.S. I've searched the forum for 'Fault Type 11', but none of posts helped.
Regards.