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
counters.

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
asap.

Data Area [and Data Queue] objects can be journaled; these often are considered a better fit for the task than a /file/.

<http://www.ibm.com/support/knowledgecenter/api/content/ssw_ibm_i_71/cl/strjrnobj.htm>
_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.

<http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzcsequence.htm>
_CREATE SEQUENCE_
"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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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 [javascript protected email address].