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