Gloss Mathias wrote:
No, I use mod_perl with connection caching, via the ODBC interface, but from sapdbs point of view it's the same.I have a webapplication that uses SAP DB, it caches the database connections between requests so I don't need to re-connect every time.
do you use PHP with persistant connections?
n/a, what do you mean?In this particular instance there were 10 apache processes and around 10 database connections, the MAXUSERTASKS parameter of the database is set to 300, so that can't really be the cause of this, right?
If you use PHP with persistant connections, how much database users do you use?
The webserver uses a single user account for all processes.
This has worked ok for months with many more database connections than now and we have not upgraded the software for a long time.
There were a maximum of 10 "DB Sessions" when we saw the "too many sessions" error as reported by:
dbmcli -u DBM,DBM -d ZDB -uSQL -c info STATE
The number of active users on the application is near zero and everything is very quiet.
--
Regards Flemming Frandsen - http://dion.swamp.dk
PartyTicket.Net co founder & Yet Another Perl Hacker
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
