How to block database connections

During a recent consultation there was a requirement to block DB2 LUW database connections. The purpose was to test monitoring alerts and assess the correct response when a database connection could not be established. The requirement was to maintain the DB2 instance active and all the other databases as online An easy way to block database connections is to use the MAXAPPLS database configurable. This parameter specifies the maximum number of concurrent applications that can be connected (both local and remote) to a database. The trick is to set the DB2 LUW database MAXAPPLS configurable to 1, and ensure that... Read more →