RE: Do I need to recreate an access path?

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Sello Walden,

This particular problem has irritated me since its inception.  If the system 
needs to update the access plan 
then it should do so regardless of the authority the job user has to the 
program object.

I do not know the name of the program but you could try turning on system 
auditing for authority violations 
and then try running the SQL program under a suitably restricted profile.  An 
entry may show up in the 
journal.  I am not sure if Q* programs are exempted from authority violations.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
//--- forwarded letter -------------------------------------------------------
> X-Mailer: Internet Mail Service (5.5.2232.9)
> Date: Sat, 30 Jan 99 16:54:25 -0500
> From: "Walden Leverich" <walden@techsoftinc.com>
> To: MIDRANGE-L@midrange.com
> Reply-To: MIDRANGE-L@midrange.com
> Subject: RE: Do I need to recreate an access path?

> 
> Soes anyone know the name of the IBM program that actually changes the PGM
> object, updating the access plan? I'd be interested in changing the IBM
> program to run as *Owner instead of *User and changing the ownership to
> QSECOFR. Thoughts?
> 
> -Walden

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