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

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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!).