sponsored by BMC Software, Inc.
Posted:  30 Nov 2009
Published:  30 Nov 2009
Format:  PDF
Length:  13  Page(s)
Type:  White Paper
Language:  English
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.

Code Management | Data Centers | Database Design | Database Performance Management | DB2 | Network Performance | SQL | SQL Server | z/OS

View All Resources sponsored by BMC Software, Inc.

About TechTarget:

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines

All Rights Reserved, Copyright 2000 - 2014, TechTarget | Read our Privacy Statement