Insufficient system resources exist to complete the requeste

[SURA]

Hi All

Using Datastage 8.1 on Windows with SQL Server 2008 R2 as a target.

Trying to load 80 million reocords from Dataset to SQL Server.

Job is keep on aborting with the below error.

APT_CombinedOperatorController,6: Unable to map file /Z=/IBM/Datasets/LoadData.ds.xxx.server.0000.0006.0000.57b0.cfb05995.0006.599f6181: Insufficient system resources exist to complete the requested service.

The error occurred on Orchestrate node node7 (hostname SERVER1)

When this job is running found the SQL Server is using full memory of 64GB and then in a min job is aborted.

Now sure how to proceed further.

I am investigating.

If any one have good suggestion, please let me know.

Thanks,
DS User

[ray.wurlod]

Looks like 64GB isn't enough to process that many rows, particularly if you're making them all into a single transaction.

How are the resources on the DataStage engine machine?