Add block to queue failed

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

Post Reply
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Add block to queue failed

Post by ray.wurlod »

ram.m via email wrote:Hi Ray,

I am getting below error while processing the 55 lakhs records for fact table..


i am sorting the data by using sort stage ,after that am aggregating the data by using aggregator stage.


buffer(0),1: APT_BufferOperator: Add block to queue failed.This means that your buffer filesystems all ran out of file space, or that some other system error occurred.
Please ensure that you have sufficient scratchdisks in either the default or "buffer" pools on all nodes in your configuration file.

Could u pls guide me any envirnment varible to handle


Thanks in advance
Ram
DSXchange is an all-volunteer site whose members post as and when they can. Five or six of those are "premium posters" whose entire content may be viewed only by premium members. This is a mechanism used to help fund the hosting and bandwidth costs incurred by DSXchange.

Approaches via private email are regarded as requests to engage the person concerned on a commercial basis. If you wish to do that, then please revert with a Purchase Order or request for quotation.

You may also like to refer to this post.

Otherwise post your question on the appropriate forum at DSXchange. You will benefit by having more than one potential respondent, and other DSXchange members (including future searchers) will benefit from the answer (if there is one) being available to all.


U is the name of one of our members. He is currently on a server-only site and would not be able to answer questions about parallel jobs. The second person personal pronoun in English is spelled "you", not "u". DSXchange is not a mobile phone; please do not use SMS-style abbreviations when posting here. Prefer a professional standard of written English. This benefits those whose first language is not English.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply