Hi

Thanks for replying

Actually I am trying to build a package for connection pooling,I am working in a project where we are developing perl scripts to connect to DB2 database and perform some business logic in a unix environment.

The actual requirement is instead of connecting to the database n number of times,get a connection from the database keep it in a pool and reuse it,so the performance can be improved.

I tried this using resource pool but I am facing some issues,can you please advice on to which cpan module will be helpful.

How are these works related? If only one can be active at a time, just put the DB connection into a variable and reuse it in the different workers.

If not, look into DBI::Proxy and DBI::ProxyServer.

Perl 6 - second systems done right