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

Appendix B. DB2 SQL Terminology

Every DB2 application requires three components to operate: the system, the database, and the application itself. The system refers to the DB2 subsystem installation, the database refers to the database objects that house the application data, and the application is the host language and SQL code that process the data for the users. To effectively deliver good DB2 performance, system programmers, database analysts, and developers must be able to monitor and tune each of these components.

Cardinality

Cardinality usually refers to a column and the number of distinct values for that column across all rows of data in a table. For example, say that the EMP table has 42 rows where there are 42 different values for the ...

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