ETL job uses temporary tablespace - where this option set?

[sharathkedika]

Hi,
While loading from one table to another table in ETL job, ETL uses temporary tablespace called PSTEMP and it is giving error "Unable to extend temp segment by 256 in tablespace PSTEMP".

But we did not set explicitly anywhere in the job which tablespace it should use temporarily.

Could you please let me know where this option is set? (use PSTEMP as temporary tablespace).

All our jobs are failing because of this reason. We increased the PSTEMP to maximum extent, still the jobs are failing.

If we find out where this option is set, we can change the temporary temp space.

Thanks,
Sharath

[ray.wurlod]

This is not DataStage at all, but rather your database server. Ask your DBA about how PSTEMP tablespace is configured, and perhaps to allow automatic expansion. A bribe may be required.