Hi,
when we try to do a lookup we get the following error
GENDER_TYPE_LOOKUP,12: Insufficient blocks for partition 12. Reading suppressed.
TAX_REGN_LOOKUP,12: Insufficient blocks for partition 12. Reading suppressed.
TAX_REGN_LOOKUP,10: Insufficient blocks for partition 10. Reading suppressed.
Can somebody tell me what this means? and how we can fix this?
thank you.
Insufficient blocks for partition error
Moderators: chulett, rschirm, roy
-
us1aslam1us
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Tell us what you're trying to do.
At a guess you are performing "normal" (not sparse) lookups into a Lookup stage, and there is insufficient memory to load those rows from the reference table into a virtual Data Set on the nodes indicated.
The best fix, if this is the problem, is a hardware solution (more memory). Otherwise you may need to re-write the job using a Join stage rather than a Lookup stage.
At a guess you are performing "normal" (not sparse) lookups into a Lookup stage, and there is insufficient memory to load those rows from the reference table into a virtual Data Set on the nodes indicated.
The best fix, if this is the problem, is a hardware solution (more memory). Otherwise you may need to re-write the job using a Join stage rather than a Lookup stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.