Big lookup: cannot allocate memory error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

stefanfrost1
Premium Member
Premium Member
Posts: 99
Joined: Mon Sep 03, 2007 7:49 am
Location: Stockholm, Sweden

Post by stefanfrost1 »

Have you tried to force the lookup to be partitioned? Maybe you will be able to spread your data across nodes and therefore minimize your overall volume....

...btw duplicates are not allowed, if you have a duplicate there will be a warning in the log telling you that a record has been discarded due to duplicates on unique values.
evans036
Premium Member
Premium Member
Posts: 72
Joined: Tue Jan 31, 2006 11:13 pm

Post by evans036 »

stefanfrost1 wrote:Have you tried to force the lookup to be partitioned? Maybe you will be able to spread your data across nodes and therefore minimize your overall volume....
that is a good idea and will likely work in most cases.

This is an excercise where i am trying to understand what memory constraint is causing the lookup to fail. I need to do this to help us write robust DS code.

thanks for the suggestion,
steve
stefanfrost1
Premium Member
Premium Member
Posts: 99
Joined: Mon Sep 03, 2007 7:49 am
Location: Stockholm, Sweden

Post by stefanfrost1 »

Ok I see..

Not sure if these will help you but in a tes scenario its worth a shot. They are set at project level in administrator and will print some additional information in the log...

APT_LOOKUP_VERBOSE
Causes the lookup operator to print some information when it
has completed loading a lookup table into memory.
APT_PM_PLAYER_MEMORY
Causes each player process to use APT_LOGMSG to report the
process heap memory allocation when returning from
runLocally().
evans036
Premium Member
Premium Member
Posts: 72
Joined: Tue Jan 31, 2006 11:13 pm

Post by evans036 »

stefanfrost1 wrote: APT_LOOKUP_VERBOSE
Causes the lookup operator to print some information when it
has completed loading a lookup table into memory.
APT_PM_PLAYER_MEMORY
Causes each player process to use APT_LOGMSG to report the
process heap memory allocation when returning from
runLocally().
thankyou very much, i'll look into these

thanks again,
steve
Post Reply