Re: Database server jobs and SQL tuning

[MacWheel99@xxxxxxx]

>  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
+---