Max number of simultaneous connections

[beckhamrryyaann]

I can't find this info anywhere else, so I thought I would ask the writers of this connector. When using DBPool what is the max number of simultaneous connections to my IBM i? I realize the answer depends. The application I need to support can have the possibility of at least 100 connections going on at the same time. I know in theory 100 sounds trivial. I would hope it could handle thousands, but it seems there was a 120 max on numbers of connections made?? Also is there any documentation on what takes place on the IBM i DBPool is created and used. What job does it run under? Is there a new job for each connection that is made and that job goes to standby when idle? One job per connection, or can multiple connections run in single job? How do i safeguard against threading issues....can multiple connections ever run in same job causing issues? I had an issue yesterday where I called a stored procedure (calling RPGLE) using DBPool.prepareExecute. The rpgle program had an exception and halted needing message answered. This caused major issues with my DBPool. How do I handle an exception in my stored procedure call....its like it just hangs and never returns...thus never closing the connection.

Again, I can't find this info on the web anywhere and really need to understand how DBPool works so I can design the best way possible.

Thanks for any info you can give.