Re: Still necessary/recommended to rebuild data queues regularly?

Mark

Had the same question - and user queues DO have the autoreclaim, as well, you just have to go to the 3rd or 4th optional parameter group. :-)

The auto reclaim does occur ONLY when the queue is empty. And I suppose the assumption is a queue will be run through, not building up forever.

Vern

On 2/18/2011 2:36 PM, M. Lazarus wrote:

Jim,

You mentioned "user queues." Just to clarify,
this discussion is referencing "data queues,"
where the AUTORCL parm was added, not "user
queues." They are different object types. I'm
not sure if user queues had this parm added too.

-mark

At 2/17/2011 04:32 PM, you wrote:

Yes. Sorry I didn't carry my prior reply to its
logical end: We found that queues that were
heavily used would bump against the 16MB storage
limit for queues, and we found no way around
that other than the destruction and recreation
of the queue. (We were never convinced that
space was released - even on an empty queue with
AUTORCL(*YES) specified - but that's another matter entirely.)

Unless the AUTORCL function has been changed
such that non-empty queues will be reclaimed, we
found the whole management of the queues
problematic. A real shame since the user queues
are so very fast and light on resource usage but
we eventually had to abandom them on high
transaction-rate processes (just where they shine the most!).