Like always. It all depends on volume and number of active users you could have.

10 user with 4 sdi process each. Piece of cake
but as you can see, the number os apps connected to the database can increase significantly, and each connection will consume some sort of memory from it. So size It properly

db2 can handle thousands of connections ( i support system that runs 20k active connections in avg). But the server and db should be sized and configured properly.

But this only covers the resouces aspect. The latency to startup a new “child” sdi process will be for sure higher from the end user perspective, when compared with embedded db (dat files) as the connection to db needs to happen for all of them. You will be going to authenticate the same user over and over.


It may never bite you. But there is always a possibility... so just a heads up.