Re: Do I need to recreate an access path?

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

Bill Robins wrote:

> Sorry, everyone.  I have led you astray.  Let me try again.
>
> I have a set of SQL's running in batch (using Pro Data's SQL4/Less product) 
>that
> is taking longer than I would like. So, I started debug and set the job
> parameters to tell me everything that is going on.  -- We are running under
> V3R2.
>
> Here is what is disturbing me: some of the access paths that -I- would have
> chosen to use in the query are not used due to reason 8 - "The CCSID of the
> current job is different than the CCSID of the job that last created this 
>access
>
> plan."  I would think that if this were a true message that the current run of
> this
> job would reset that access path so that the next run of this program would 
>not
> create this message, but that is not true.
>
> The job's CCSID is 37, so is the file's.  I guess the question is how do I get
> the plan to reset and use the CCSID 37? Or am I missing something else?
>
> Bill
>

So, I repeat....

The system is normally defaulted to 65535 (or something).  Chances are the 
program
was compiled while the CCSID was that default value, or some other and you have 
(or
someone) has changed everything to 37.  So... recompile.  The access plan is 
built
for static SQL during the compile.

Remember, Access Plan not Access Path.

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



--
===========================================================
R. Bruce Hoffman, Jr. -- IBM Certified AS/400 Administrator

-- The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!

begin:          vcard
fn:             R. Bruce Hoffman, Jr.
n:              ;R. Bruce Hoffman, Jr.
adr:            991 Lucon Road;;;Schwenksville;PA;19473;USA
email;internet: rbruceh@ibm.net
title:          Independant AS/400 Consultant
tel;work:       610-222-9707
tel;fax:        610-222-9717
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard