DB2 Performance Summary Part 2

Make sure that you are using the correct database design to improve DB2 performance:

Use partitioning for robust tables that play central parts in the processing to help ease locking and encourage parallelism. Also leverage database partitioning for large tables (over 500,000 rows) which might benefit from spreading out the I/O to different partitions and . . . → Read More: DB2 Performance Summary Part 2

Taking Advantage of Relational Technology

Last time we looked at the application design of a major DB2 system. Now, let’s delve a little further and look at the SQL used in these applications.

Taking Advantage of Relational Technology

During reviews of various client systems, analyzing the SQL used is very helpful for understanding how sophisticated the shop and system are . . . → Read More: Taking Advantage of Relational Technology