Re: Gathering data from multiple systems

[Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>]

Ryan Moeller is a super cool guy at IBM in the Db2 group. Scott Forstie has
always been my guru, but now I have two gurus !!

All Ryans stuff is cool - just look here ( I just hope he one day will
convert to lower case - I hate when SQL shouts at me) :

https://gist.github.com/ryan-moeller21/

btw my stuff is here:

https://gist.github.com/NielsLiisberg

.. Perhaps we could share all our gists somewhere sometime...







On Mon, Mar 23, 2026 at 8:31 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> Just saw an open sourced item used which gathered information from multiple
> LPARs of IBM i.  Thought it was really cool.
>
>   CALL COOLSTUFF.AGGREGATE_REMOTE_SQL_SERVICE_DATA( REMOTE_SYSTEMS =>
> 'COMMON1, COMMON75, COMMON76', SQLSERVICE_SCHEMA => 'QSYS2',
> SQLSERVICE_NAME => 'ACTIVE_JOB_INFO', SELECT_LIST => 'JOB_NAME, CPU_TIME,
> TEMPORARY_STORAGE, TOTAL_DISK_IO_COUNT', PREDICATES => 'CPU_TIME > 10000',
> LIMIT => 5 );
>
> Source code:
> https://gist.github.com/ryan-moeller21/758a7d048040c8fdad663a59d2e5a219
>
> Presentation I first noticed it in:
>
> https://learn.common.org/products/sql-for-system-and-storage-management#tab-product_tab_handouts
> --
> 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.