Re: Do I need to recreate an access path?

Perhaps,

APAR#: SA64371
Release(s): R370
RC 8 does NOT match the problem description.  The reason
why the index is being rebuilt is NOT due to CCSIDS but
because of the Dynamic SQL forcing the rebuild.
A correction needs to be made to the error message text.  To
state that the reason for the rebuild is because that Dynamic
SQL forced the rebuild of the index.

Dick Lucas

-----Original Message-----
From: Bill Robins <brobins@ix.netcom.com>
To: Midrange Discussion List <midrange-l@midrange.com>
Date: Friday, January 22, 1999 2:09 PM
Subject: Do I need to recreate an access path?


I have a set of SQL's running in batch 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.

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

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

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

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