Re: qsys2.user_info_basic

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

It does take a few seconds.  Hardly 40 on my machine.
Statement ran successfully   (9,677 ms  =  9.677 sec)

Fresh connection after reboot of pc.
Cume:  23110, TR2, DB2-8

On Thu, Aug 31, 2023 at 2:44 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Keeping in mind we just upgraded from 7.3 to 7.5 ten days ago... we just
> noticed today how slow this UDF is.
>
> In run sql scripts, the following takes about 40 seconds to return a few
> hundred rows of users.  The odd thing is that the "basic" takes twice as
> long as the qsys2.user_info.  This previously only took a few seconds.
>
> Anyone else see this?
>
> SELECT
>   user_name,
>   prvsignon,
>   signoninv,
>   status,
>   pwdchgdat,
>   usrcls,
>   text
> FROM
>    qsys2.user_info_basic
> -- qsys2.user_info
> WHERE
>   (
>     user_name not like 'Q%'
>     and nopwd = 'NO'
>   )
> ORDER BY
>   user_name
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.