Reduce CPU Usage with 'SMART' SQL

Reduce CPU Usage with 'SMART' SQL

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.
BMC Software, Inc.
30 Nov 2009
30 Nov 2009
13 Page(s)
White Paper
Already a Bitpipe member? Login here

Download this White Paper!

By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Safe Harbor