Re: File Trigger Performance

On 4/9/2018 11:50 AM, Rich Loeber wrote:

Seems easy enough, but the customer is reported very poor performance now
on batch applications.

Any ideas?

It's too bad the customer didn't share more information about the
system, the application, the volume of transactions, or the nature of
the performance degradation, or its magnitude. They'd get better
quality ideas other than reverse whatever changed between 'then' and 'now'.

Currently IBM i 7.3 TR3, but I've had the same architecture in place
through 5.4, 7.1 and 7.2, with I/O being done variously by RPG RLA and
embedded SQL. I have no performance problems to report with this
architecture for these many years, nor do I recall any performance
changes. That said, there are often DB2 PTFs that affect performance,
so getting current is a useful action.