Re: RPGLE Converted into SQL having performance issue

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Thanks, Frank

Those things are now very easy to use in ACS - you don't need to run DB 
monitors, you can get Visual Explain over almost any SQL statement in 
any job.

Cheers
Vern

On 12/15/2020 3:33 PM, Frank Kolmann wrote:
> Thanks Vernon
>
> To be specific it is the commands   STRDBMON  and PRTSQLINF
>
> In particular find any Index advised messages, then create the 
> suggested index using SQL.
>
> This is a very basic and simple process and should be part of any 
> database administrators function if you use SQL.
> Read the manual or google IBM sites on the use of these commands.
>
> Its been a while so I am a bit rusty, but it has never failed me.
>
> Frank
>
>
>
> On 16/12/2020 12:11 am, Vernon Hamberg wrote:
> > Ashwani
> >
> > To add to Frank's suggestion, I think he is talking about Visual 
> > Explain and the performance monitors - I've not heard of the term 
> > "SQL logs" myself, but that's what I think he means.