O'Reilly logo

DB2 SQL Tuning Tips for z/OS Developers by Tony Andrews

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. SQL Standards and Guidelines

Every IT shop that has applications involving DB2 should have a set of SQL standards and guidelines for its developers to follow. This chapter is a start for developers and project managers to use as part of their development. Once you have a set of standards and guidelines, be sure to enforce them. Every program should have code walkthroughs to ensure that standards and guidelines are being followed.

The standards and guidelines that follow serve multiple purposes:

• Relate to performance

• Alleviate abends and/or production incident reporting

• Reduce I/O and CPU costs

• Increase productivity

• Improve client satisfaction

• Improve readability and understandability

The standards and guidelines that follow ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required