×
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 16-May-2016 08:23 -0500, Steinmetz, Paul wrote:
1) How would I check for SQL usage you mentioned?
Re Query Engine implementing a query with a keyed Access Path
(ACCPTH) defined by a Logical File (LF) [associated with a Logical File
Member (LFM)]
2) I also turned on object auditing for this LF
Not sure what to look for to confirm usage.
If even such AccPth /usage/ is tracked by auditing, which I doubt,
then there would be an object-read-access T-ZR entry for the LF;
presumes also, IIRC, the setting of OBJAUD(*ALL) for the Logical File
*FILE object.
It was used once again this morning by a once a week process.
AFaIK the last-used-date of the LF\LFM, per reference by query for
implementation, is offered only as a means to ensure usage tracking;
i.e. to prevent an appearance of unused\obsolete. That same /usage/ is,
AFaIK, not tracked additionally for auditing purposes; auditing being
satisfied instead, by access to the underlying data [each PFM opened,
over which that Access Path is defined] having been audited.
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
