Maximum connections allowed on a DB2 database - MAXAPPLS and MAX_COORDAGENTS

Question: How can I find out the maximum amount of connections allowed on a DB2 database? Answer: Work through this example to analyse the connections. The example indicates support for 68 (with room to grow) and the high watermark is 38. To check at a database level check MAXAPPLS . This parameter specifies the maximum number of concurrent applications that can be connected to a database. db2 get db cfg for DB_NAME | grep 'MAXAPPLS' --returns Max number of active applications (MAXAPPLS) = AUTOMATIC(68) To check at an instance level check : MAX_COORDAGENTS , which is used to limit the... Read more →

Db2 reduce tablespace with ALTER TABLESPACE REDUCE

There was some unexpected growth on a DB2 database server during the business day. Various jobs begin to fail due to disk issues . There was an immediate requirement to release space to back to OS. Sometimes unexpected growth occurs , regardless of scheduled reorganizations and capacity planning. The ALTER TABLESPACE REDUCE is useful in these circumstances. Depending on whether the tablespace is set at automatic or non-automatic auto storage there is a different approach. For non-automatic storage table spaces, specifies that existing containers are to be reduced in size For automatic storage table spaces, specifies that the current high... Read more →