×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 29-Jun-2014 16:34 -0500, Peter Connell wrote:
Huge file of 74 million rcds has 301 million deleted records and
several logical files.
The Reuse Deleted Records (REUSEDLT) attribute setting plays a role
in such a scenario. Irrespective that setting, the online reorg can
assist to both purge deleted records and make the data [more]
contiguous. The Reorganize Physical File Member (RGZPFM) with the
option to Allow Cancel (ALWCANCEL) enabled can be used with an
allocation locking level that allows other work to continue [i.e. enable
the work to perform online vs requirement to take the file off-line for
concurrent work], as specified with the Lock State (LOCK) option.
<
http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/cl/rgzpfm.htm>
Can data management really handle this with little performance impact
if there are regular additions/deletions?
Random I\O [keyed] access is most probable to be the least impacted
re performance [except certain multi-format logical file accesses], and
sequential access is the most probable to be the most impacted re
performance [due to large gaps in sequence for which rows per page can
be an extremely low number including zero].
FWiW, officially the effects re performance are of the Storage
Management [the LIC SM, as accessed via the LIC DB to perform whatever
access method]; what is known as the Data Management [the OS DM],
effectively is unaware of deleted vs active records, in its role of
providing a path to the data [records; essentially only the /direct/
access method can access a deleted row].
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
