We have discovered a issue with DataStage jobs when an "ORA-01652: unable to extend temp space" error occurs during a select statement.
The issue is not regarding the Oracle error as it was found that the table statistics were stale rather it was that the DataStage job continued processing and finished with an 'OK' status hence allowing subsequent jobs in the calling sequence to run. This issue was only picked up in Development however if the jobs does not abort the error will be difficult to pick up once in Production.
Is there a config setting that needs to be enabled to make the DataSatge job fail for this kind of Oracle error?
DataStage Job not aborting despite ORA-01652 error
Moderators: chulett, rschirm, roy