Use the rich services provided by IBMi...One idea is to route the IP address in its own subsystem, you have more visibility, then you can cap at the subysstem level, see "workload capping" for hard capping in cpu, limit memory, timeslices, and the number of jobs (if one wishes, but with the resources limited this is then automatically should be self behaved).
check
https://www.ibm.com/docs/en/i/7.6.0?topic=services-set-server-sbs-routing-procedure
bye
On Sunday, December 28, 2025 at 10:59:41 PM GMT+1, smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx> wrote:
My client has a problem where non-IBMi applications (Windows servers) are
creating MANY JDBC connections to pull data.one file is 98G and is pulled in
full every day. Their app needs to finish faster so they create additional
threads to bust up the file but they never talk to us about it first. Our
system currently sits at over 100% CPU for hours at a time while these JDBC
connections are active. Last night it was 4+ hours at 150+%. This is
impacting other IBMi programs.
There is a whole lot wrong with that previous paragraph and we are actively
working on the root of the problem but it is a long process getting it
changed. I don't need help fixing that part of the problem so please don't
offer solutions for it.
The problem that I am trying to solve is how to limit the number of JDBC
connections from a single IP address. They are connecting through a job
named QRWTSVR (or something close to that). When I look at the joblog, I
can see what IP address did the connection. I have gotten permission to
limit an IP address to 5 threads and if they try to open a sixth, it will
fail. This sixth connection's failure assumes all of the first five jobs
are still active. If one has ended / disconnected, the sixth connection
should be allowed. My problem is how can I do it? Is there a way through
an exit point? I've been looking but not finding anything. The exit points
that I have found do not show me the job information.
Does anybody have any thoughts that I can research to find a way do to this?
midrange.com
