Re: PF member current number of increments larger than the max

Ok, IBM actually supplies a sample trigger for just this sort of thing.
Basically you set a trigger on SYSLIMTBL for a particular limit code.

First, before creating the trigger let's query the syslimtbl for rows
telling us that a particular PF has exceeded their maximum size.
select *
from qsys2.syslimtbl
where limit_id = 15000;

I have some which tell me that ERPLXF/LCH has blown past it's limit. While
it doesn't tell me the limit, it does tell me that it has almost 11
million rows in it. I had to use DSPFD to find that the limit was 10
million. I still haven't found any information that is a direct one to
one with the SIZE parameter on CHGPF.

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/Tracking%20Important%20System%20Limits

click link
See this presentation for details:
System Limits on IBM i
It will have the sample trigger.

https://www.ibm.com/developerworks/community/wikis/form/api/wiki/beb2d3aa-565f-41f2-b8ed-55a791b93f4f/page/41834289-d0ff-463a-ac41-f429357b2a4f/attachment/adb84a9d-5624-45ed-b389-b7a0e6e8634d/media/System%20Limits%20on%20IBM%20i%20-%20January%202018.pdf

So now when the database writes out a new 15000 limit reporting that some
table's partition (aka member) has exceeded it's maximum number of rows it
will activate your new trigger.

Rob Berendt