×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Most of the time when reviewing batch jobs which seem to take an
inordinate amount of time the goal is to reduce I/O's.
My best example was a developer who coded this
Clear summary file;
Read detail file
Try to update row in summary file, if update fails try write
next
Extreme numbers of I/O to summary file. Changed to
Read detail file in order of desired summary rows;
sum total in memory
at control break time write out the total to summary file
Shaved off an hour.
In your case you could look at a number of things.
TRCJOB for one.
Another thing to look at is
select system_table_schema, system_table, system_table_member,
open_operations, close_operations, insert_operations, update_operations,
delete_operations,
...
from qsys2.syspartitionstat
where system_table in ('FROMFILE', 'TOFILE')
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzcatsyspstat.htm
Run that before and after the batch job.
Rob Berendt
midrange.com
