We are using a cluster with 2 nodes.
Node 1 is an application server,
Node 2 is the db server (db2).
It seems when I start the application, the application establishes a connection to the application server and the application server connects to the database.
Now we have more and more employees who use this application.
Since longer time we noticed the problem that only 60 users can work with the application at the same time.
Today I wanted to add some users to the database with the application. As I noticed that already 60 users are connected, I wanted to do it manually on the db servers command line. But as I wanted to connect to the db with "db2 connect to xxx" I got the error message "SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030".
As I checked the database configuration I saw that there is a parameter called MAXAPPLS which is set to 60.
Can anyone tell me how I can increase the value of this parameter and if anything else is to do to increase the maximum concurrent connections to the database???
Well... the problem is that the whole system is really old and we don't want to invest much more money in this system because we want to replace this system by another one.
The new system will be ready not before the next 2 years. So we try to make the best with the existing one ;-)
Please can you tell me the command to change these parameter values?