Job hanging when using $APT_ORA_IGNORE_CONFIG_FILE_PARALLEL

ssunda6 · Post by **ssunda6** » Mon Jul 02, 2007 11:08 pm

Hi All,

I am using LOAD option in oracle stage. To further improve performance, heard we can use oracle environment variable:

$APT_ORA_IGNORE_CONFIG_FILE_PARALLELISM

When we set its value TRUE, it should automatically partition datastage data to match oracle partitions.

But when I use the above variable, the job gets stuck. Status of the job is shown as RUNNING.

Can anyone please tell me what the problem is?

Regards,
ssunda.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 7:24 am

It's difficult to say - you haven't really supplied enough information for diagnosis. For example, have you specified a partitioned table? If so, do you have the requisite SELECT privilege on the system tables?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 7:25 am

It's difficult to say - you haven't really supplied enough information for diagnosis. For example, have you specified a partitioned table? If so, do you have the requisite SELECT privilege on the system tables?

ssunda6 · Post by **ssunda6** » Thu Jul 05, 2007 11:27 pm

Hi Ray,

The table is partitioned and yes, there is SELECT privilege to the ID that I am using

Regards,
ssunda.