RE: Data Queues

Yes there is a limit to the size of a data queue.  2500 x 592 = 1,480,000.
Now add the other information such as sender ID, 44 char, Key etc and you
will get the real length of the data queue.  We use a size of 2000 in an
unkeyed data queue and our magic number is 8208 records before the object
overflow.  Once a data queue reaches it allocated space it tries to grow
enough to handle a another block of entries.  If the space required to add
the next block exceeds the max object size for data queues you run into the
over flow error.

Two solutions:

1. Reduce the max entry size on creation of the data queue to what you
really need.  If you never put more than 1000 bytes in an entry, make that
the max size.  Also do you really need sender ID? 

2. Can you start more processes to pull entries off the data queue so you
don't fall so far behind?  If you have a program that wakes up and processes
the entries then sleeps when all done, shorten the sleep time.


Christopher K. Bipes     mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst   mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.         http://www.cross-check.com
6119 State Farm Drive    Phone: 707 586-0551 x 1102
Rohnert Park CA  94928 Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000


-----Original Message-----
From: Michael.Franchino@cussys.com [mailto:Michael.Franchino@cussys.com]
Sent: Wednesday, May 31, 2000 10:11 AM
To: MIDRANGE-L@midrange.com
Subject: Data Queues


All,

I am having a problem that I have never encountered before.  It is on a
DTAQ.. The message
is CPF950A (Storage limit exceeded for data queue ....)

This software has been running for 4 1/2 years at over 300+ customer sites,
and this is the first
time I have ever seen this problem... Is there a storage limit for a data
queue?? I can't seem to
find it..

Some details:

The data queue is keyed, with a record length of 2500.. There appeared to
be 592 entries in the
data queue before it died.. The data queue gets recreated almost daily...

The machine it is running on is at V4R3.. I can't recreate this on my own
AS/400, and am really stumped

TIA.

Michael Franchino
Custom Systems Corporation
(973) 383-7808 X214 (Phone)
(973) 383-6398 (Fax)
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---