Re: DB2 Services - object_lock_info

[Craig Richards <craig@xxxxxxxxxxxxxxxx>]

Ah ok - that makes sense

Thanks Birgitta

On Mon, 8 Apr 2019 at 12:25, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:

> The view join multiple UDTFs and other views together and select ALL and
> then your selection is acced.
> You may have a look at the UDTFs directly and check whether they return all
> information you want. Passing parameters instead of selecting from the
> complete result should be much faster.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Craig
> Richards
> Sent: Montag, 8. April 2019 12:11
> To: RPG programming on the IBM i (AS/400 and iSeries)
> <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: DB2 Services - object_lock_info
>
> Hi all,
>
> I am trying to use
> OBJECT_LOCK_INFO view
> to get some information for a dashboard.
>
> In the following SQL:
>
> select job_name from object_lock_info where system_object_schema in( select
> datalib from cisys/msgsrv00) and system_object_name in('WS010R', 'WS090R',
> 'GL010R', 'GL090R',
> 'GL050R')
>
> the msgsrv00 table only contains 7 rows.
>
> I'm only selecting one column (job_name)
>
> But this SQL takes approx 1 minute to run.
>
> Is there some other way I should be using this view to get locking
> information?
>
> I found a similar issue when using
> OUTPUT_QUEUE_ENTRIES view
> in that the response was very slow.
>
> I guess I must be doing something foolhardy as the response times I'm
> getting are way higher than I'd expect.
>
> Any comments / advice gratefullly accepted.
> thanks,
> Craig
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list To post a
> message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> https://amazon.midrange.com
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com