Re: Comes with 7.5

Shameless plug here. Job Scheduler info can found on my IBM i Reference Pages blog @ https://ibmireference.blogspot.com/.
Open the IBM i Tips page. Both WRKJOBSCDE and GO JS info listed.


Very Respectfully,
Michael Mayer
IBM i on Power System Admin.
ERMCO-ECI
Cell: 518.641.8906
On Call: 731.676.4318
IBM i Reference blog page: http://ibmireference.blogspot.com/



4. Re: Comes with 7.5 (Vern Hamberg via MIDRANGE-L)


----------------------------------------------------------------------

message: 4
date: Fri, 1 Sep 2023 22:39:07 -0500
from: Vern Hamberg via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: Re: Comes with 7.5

Hi Gad

Rob was nice to you, giving you these links. They are both in Knowledge Center, if you are in the US, you should be able to go there. Db2 Multisystem, well, Db2 is database, so you could look there. Advanced Job Scheduler was a little harder - but a filter or search in Knowledge Center got me right there to it easily. Of course, there is always Google.

Regards
Vern

On 9/1/2023 9:29 AM, Rob Berendt wrote:

RTM?

Advanced Job Scheduler
https://www.ibm.com/docs/en/i/7.5?topic=options-advanced-job-scheduler

DB2 Multisystem
https://www.ibm.com/docs/en/i/7.5?topic=reference-db2-multisystem

Basically DB2 Multisystem is a way to get IBM i to support multimember
files. Instead of manually creating members like M2023, M2022,
M2021 and storing the proper years data into them manually you could
use an sql command to create such a partitioned (sql for member) table
which will automatically assign a row based on a value of a column.
Take
year(order_date) for example. Research the CREATE TABLE statement for
more info.
The reason it's called multisystem is that the members can be on
physically different machines. Think partitioning by warehouse.
When IBM i started supporting Temporal Tables the history tables could
get quite large and most of IBM's examples of creating temporal tables
included having the history tables partitioned.
I submitted a RFE to get partitioning for a single system broken out
of DB2 multisystem. IBM rejected that RFE and decided to stop
charging for DB2 Multisystem. I can accept that.



On Fri, Sep 1, 2023 at 7:10?AM Gad Miron <gadmiron@xxxxxxxxx> wrote:

Hello guys

Having installed 7.5 I noticed that AJS and DB2 Multisystem are now
included in 7.5 with no additional charge.
Where can I find some hands-on instructions for these two LICs?

TIA
Gad
--
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.

------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 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.



------------------------------

End of MIDRANGE-L Digest, Vol 22, Issue 799
*******************************************

________________________________
Please note: Florida has very broad public records laws. Many written communications to or from The Florida Bar regarding Bar business may be considered public records, which must be made available to anyone upon request. Your e-mail communications may therefore be subject to public disclosure.