databasejournal.com databasejournal.com

Cooling Your Overloaded Database with New DB2 UDB EEE Partitions

Marin Komadina Today the server hardware is so powerful that it is not unusual to find standalone low cost SMP (Symmetric Multiprocessing Machine) servers in different clustered and non-clustered configurations. Data volume and the number of concurrent database connections on those systems are rising higher and higher. When we approach warning levels in our hardware utilization we can simply expand the system with more hardware...

databasejournal.com databasejournal.com

Cooling Your Overloaded Database with New DB2 UDB EEE Partitions - Page 3

Marin Komadina Procedure for Adding New Database Partition This system has performed very well, until we doubled the data volume which resulted in increased CPU and memory utilization. This can be solved by adding more memory and new CPUs. After that, we are going to create a new database partition on added the hardware and redistribute the user data across all partitions. Hardware upgrade We upgraded the hardware to...