On 04-Dec-2014 14:42 -0600, Gary Thompson wrote:
Michael Smith on Thursday, December 04, 2014 1:39 PM wrote:
<<SNIP>> several user spaces that we use as "next sequential" number
The value of the user spaces when the system came back up did not
reflect updates that had occurred during the day, and as a result
various files had duplicate "sequential" numbers.
My question, is there a function for a user space that is similar to
FRCRATIO for a database file?
<<SNIP>> My 2 cents is change your user space to a journaled file
Data Area [and Data Queue] objects can be journaled; these often are
considered a better fit for the task than a /file/.
_Start Journal Object_ (STRJRNOBJ)
"The Start Journal Object (STRJRNOBJ) command is used to start
journaling changes (made to an object or list of objects) to a specific
journal. The object types which are supported through this interface are
Data Areas (*DTAARA) and Data Queues (*DTAQ). ...
FWiW: The Database SQL SEQUENCE object is implemented as a Data Area;
there is a CACHE clause to imply how well to protect the sequence values.
"The CREATE SEQUENCE statement creates a sequence at the application server.
_CACHE or NO CACHE_
Specifies whether to keep some preallocated values in memory.
Preallocating and storing values in the cache improves the performance
of the NEXT VALUE sequence expression. The default is CACHE 20.
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact