Thursday, April 17, 2014

SQL1040N The maximum number of applications is already connected to the

If Maximum number of connections is reached, we get below messages,
db2inst2@db2v10:~> db2 connect to testdb
SQL1040N  The maximum number of applications is already connected to the
database.  SQLSTATE=57030


In db2diag, we will get below message,

2014-04-17-13.41.49.929364+330 I2038E599             LEVEL: Severe
PID     : 8786                 TID : 140315335845632 PROC : db2sysc
INSTANCE: db2inst2             NODE : 000            DB   : TESTDB
APPHDL  : 0-156                APPID: *LOCAL.db2inst2.140417081149
AUTHID  : DB2INST2             HOSTNAME: db2v10
EDUID   : 59                   EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::SubsequentConnect, probe:10117
RETCODE : ZRC=0xFFFFFBF0=-1040
          SQL1040N  The maximum number of applications is already connected to

          the database.

Now to check the maximum number of threads allowed, and high water mark for number of threads in an instance, use below commands,

db2 connect to dbname

db2 get db cfg | grep -i MAXAPPLS ==>at db level

db2 get dbm cfg | grep -i max ==> at instance level

db2 get snapshot for dbm | grep -i high ==> give hig water mark for db conenctions

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home