Reduce CPU Usage with 'SMART' SQL

Cover Image
The initial problem that causes most organizations to waste a great deal of CPU resources comes from unnecessary calls to the DB2. This is often an innocent mistake, but over time it adds up to be one of the largest undetected performance problems. Why undetected? Simply put, the SQL appears to be 'perfect' and, therefore, no additional tuning efforts are made.

The problem with this is that the SQL is not doing anything but calling DB2 like a common I/O module, and not using advanced SQL syntax for performance. This is not a proper usage of the DB2 engine, and it results in the worst possible performance.

This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to:

  • Write SMART (SQL Made to Accurately Reflect Transactions) applications rather than writing applications that act like generic I/O modules to DB2
  • Properly tune SMART SQL to further reduce CPU and execute efficiently
  • Exploit SQL and application features in DB2 on z/OS version 8 and 9 to help with these efforts.
Vendor:
BMC Software, Inc.
Posted:
Feb 8, 2021
Published:
Nov 30, 2009
Format:
PDF
Type:
White Paper
Already a Bitpipe member? Log in here

Download this White Paper!