Active Prestart Jobs in New Navigator
By Dawn May / October 13, 2021
With New Nav, you have a graphical user interface and you no longer need to craft your own queries to get at the data. Learn the benefits from Dawn May here.
IBM provides an example service, Prestart jobs statistical review, in Run SQL scripts so you don’t have to craft the query yourself. (Note: there is an error in the example where “active” is not a valid column (where active = 'YES'). You need to replace “active” with subsystem_active. I like to expand this example to also include the prestart job tuning parameters (INLJOBS, THRESHOLD and ADLJOBS), so they can be reviewed in conjunction with the statistics.
Now, with New Nav, you have a graphical user interface to provide this information and you no longer need to craft your own queries to get at the data. Find active prestart jobs under the Work Management task, as the figure 1 shows:

Figure 1
This will return a table with one row for each active prestart job entry in all active subsystems on the partition. You can use the various filters to limit the results to only specific subsystems or prestart job entries. This allows you to review all the statistics for prestart jobs in one table. With a simple right-click you can change, remove or view the properties of the prestart job entry. Properties (see figure 2) displays all the statistics for that prestart job entry, which is a superset of the statistics that are displayed in the table (you can add the additional columns of information to the table).

Figure 2
If you want to review the tuning parameters, you need to select the Change prestart job entry… option, which displays the CHGPJE command in the GUI (see figure 3):

Figure 3
This support is very nice; however as I noted above, I like to display the tuning parameters in the results along with the statistics.
Tagged as:
IBM i / Linux on POWER / Article / Community / Systems management / Application development / i Can blog / SQL
About the author
Dawn May is an IBM i consultant. She owns Dawn May Consulting, LLC in the Greater Boston area. Dawn is a former IBM senior technical staff member.
See more by Dawn May