dbaplus Community

Apr 9, 2016 · Databases

The Simple SQL That Can Crash a 1TB IBM Power780 Server

The article explains how a seemingly harmless SQL statement, when executed millions of times on an IBM Power780 system with a 1 TB configuration, can overload the library cache mutex, causing the database to stall, and provides the original script, reproduction steps, and practical advice to avoid such catastrophic contention.