(Rob Williams) One of the worst default parameters for DB2 in my mind is the LOCKTIMEOUT parameter. I have seen this in a number of broken applications cause big problems. While facilities existed to find out what statements were causing deadlocks nothing similar existed to diagnose timeouts.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help