|
From "Mark Waterbury" <mark.s.waterbury@xxxxxxxxxxxxx>To "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxxxxxxxx>
Justin,
Since you are using an IBM supplied table function, or view, or whatever, (QSYS2.RECORD_LOCK_INFO), open a "PMR" or "case" with IBM Support to report this as a problem, and suggest that IBM should "fix" this.
All the best,
Mark S. Waterbury
On Friday, September 9, 2022 at 10:19:50 AM EDT, Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:
VE is recommending an index over QSYS/QADBXREF. The query in question is using QSYS2.RECORD_LOCK_INFO. I've never seen an index recommended over a QSYS table before. Is it a bad idea to create indexes over QSYS tables (they'd be in a diff schema of course).
TIA
-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
As an Amazon Associate we earn from qualifying purchases.
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.