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

[Albert York <alfromme@xxxxxxxxx>]

> Now I have transactional data queues that are deleted and recreated when the subsystem starts.  This makes sure any hung
>  transactions are purged as if we don't get a response back to the POS terminal within a few seconds, it has hung up and then
> resends the transaction to an alternate number.

I use the QCLRDTAQ API to clear the queue, rather than deleting it and
recreating it. This avoids the possibility of a job trying to send
data to a data queue that doesn't exist (even briefly).

Albert

On Thu, Feb 17, 2011 at 7:44 AM, Chris Bipes
<chris.bipes@xxxxxxxxxxxxxxx> wrote:
> It really depends on why you are deleting them and how you created them.  There are two settings to look at:  Size(*max16MB or *max2GB) and AUTORCL(*yes)
>
> Back in the day you a data queue could only grow to 16MB, now you can have it grow to 2GB.  But the reason for deleting was, if the queue grew at one time, it remained that size until you deleted and recreated it.  (Data queues are memory object so they really can be memory hogs).  Well IBM finally introduced the AUTORCL option.  This allows the data queue to shrink back to the initial size as messages are removed.  No real reason to delete on a regular basis.  I would look at the create command and make sure it specifies the AUTORCL(*YES).  Then I would stop the deleting nightly.
>
> Now I have transactional data queues that are deleted and recreated when the subsystem starts.  This makes sure any hung transactions are purged as if we don't get a response back to the POS terminal within a few seconds, it has hung up and then resends the transaction to an alternate number.
>
> We also have queues for sending transactions between systems that I do not want to lose.  Those are not deleted and we set the FORCE(*YES) to make sure they are committed to disk and not damaged in a system failure/shut down.
>
> --
> Chris Bipes
> Director of Information Services
> CrossCheck, Inc.
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Åke Olsson
> Sent: Thursday, February 17, 2011 12:34 AM
> To: 'midrange-l@xxxxxxxxxxxx'
> Subject: Still necessary/recommended to rebuild data queues regularly?
>
> Our application uses data queues "a lot" and out of habit and tradition the queues get deleted and created afresh in the overnight runs.
>
> I believe this way of handling them was an IBM recommendation some years ago.
>
> The question is: Is it still necessary to delete/create data queues like this? OR Could we just let them be - like forever. Never deleting them. Just create queues when needed and let them sit.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.