Don, Joe and Michael. Thanks for the responses. That is helpful.

After I submitted my question, I discovered that the QSYS2.OBJECT_STATISTICS table function accepts *ALLUSR as one of the parameters, so I was able to use SQL to get the list I was after.

Dean

On 1/6/2021 9:22 AM, Joe Pluta wrote:
The IBM i definition of *ALLUSR is pretty specific. It excludes
libraries starting with #, but it does include a bunch of Q libraries
like QGPL and QUSRSYS. To get the exact definition, prompt the WRKOBJ
command and then hit F1 on the Library field.

On 1/5/2021 3:52 PM, Dean Eshleman wrote:
I'm new to BRMS and I'm reviewing our current backup setup. In the
one backup list we use, it specifies *ALLUSR for the library. I
assume that it means all libraries that are not system libraries? Is
there a way for me to get a list of what libraries are "user
libraries"? I'm aware that most if not all system libraries start
with Q. I didn't know if there were any others or not. TIA

Dean Eshleman
Software Development Architect
Everence

1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network]<http://www.everence.com/careers>

Confidentiality Notice: This information is intended only for the
individual or entity named. If you are not the intended recipient, do
not use or disclose this information. If you received this e-mail in
error, please delete or otherwise destroy it and contact us at (800)
348-7468 so we can take steps to avoid such transmission errors in the
future. Thank you.



Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

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.