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


  • Subject: Re: Database server jobs and SQL tuning
  • From: MacWheel99@xxxxxxx
  • Date: Fri, 19 May 2000 14:59:54 EDT

>  From:    DBale@lear.com (Bale, Dan)
>  
>  Wow.  Is this documented, Al?  

Referring to my remarks about qualifying vs. library list

John Earl also challenged what I thought I had learned in IBM school. 

I could not find explicit clarification in any of my manuals, so I e-mailed 
question to IBM school asking what I had absorbed incorrectly on this topic & 
here is the reply from one of my IBM professors:

QUOTE

Al,

When access is requested to an object and *LIBL is specified for the object
the library list information is used to check authority for the LIBRARY. If a
qualified name is specified, the authority for the LIBRARY is specifically
checked, even if the library is included in the user's library list.

*LIBL has the system establishing LIBRARY authorities for the libs in the 
list.
Subsequent LIBRARY authority lookups are not going to be done UNLESS
the lib_name/obj_name qualification is used. The system will lookup the
authority the user has to the library every time a qualified reference is
used.

That's just for the library. The system then has to handle the security
for the object itself. Hope that helps.

Eric J. Jackson
Sr. Education Specialist - AS/400
IBM Learning Services
330 N. Wabash, 4th floor
Chicago, IL 60611

UNQUOTE

My primary interest is in correcting any misconceptions that I had had.
My conclusion from this is that my prior statement was a simplification, but 
that overall it is true that there is more security checking by qualification 
than by library list.  One thing that is not clear to me is in the case of a 
library with thousands of program objects ... including that in library list 
might result in excess checking, also hurting performance.

ie. our folks sign onto BPCS & they do not get the BPCS logo instantaneously, 
because their library list is being heavily loaded with access to approx 20% 
of the stuff in 12 Gig.  That lag does not bother me yet.

Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.