Re: PRTSQLINF -- MIDRANGE-L

Subject: Re: PRTSQLINF
From: CRPence <CRPbottle@xxxxxxxxx>
Date: Mon, 16 May 2011 10:25:35 -0700
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On 16-May-2011 06:50 , Jon Paris wrote:

On 16-May-2011 02:25 , Birgitta Hauser wrote:

Did you run your program after moving to V7 and before executing
PRTSQLINF?

Yes - several times.

Verify that the specific statement [being diagnosed by SQL5065] was or will actually be executed in a run of the program, because the output from [the v5r3 request to] DSPMSGD SQL5065 QSQLMSG suggests that:

Cause . . . . . : The access plan was not found.
If an SQL statement contains host variables,
the access plan will be created
the first time the statement is run.

Regards, Chuck

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2025 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.