Home

DB2 tuning tips for z/OS - IBM - United States

DB2 SQL Tuning Tips for z/OS Developers (IBM Press)

$3.40


DB2 SQL Tuning Tips for z/OS Developers Tony Andrews

Performance is one of the most importantfactors in any type of database system. This article focuses on anumber of DB2 performance tuning tips based on lessons learned fromrunning OLTP-type performance benchmarks (TPC-C, TPC-W, Trade2,etc.). Although performance of a database application caninfluenced by many factors, we focus on configuration rather thanon such things as capacity planning, database design, orapplication design.

This paper focuses on a number of DB2 tuning tips based on lessons learned from running Online Transaction Processing (OLTP)-type performance benchmarks (TPC-C, TPC-W, Trade2, etc.). Performance of a database application can be influenced by many factors. This paper concentrates on the configuration aspect of DB2 and does not take into account details with regard to capacity planning, database design, or application design with the exception of a few brief reminders.

DB2 SQL Tuning Tips for z/OS Developers: Excerpt

  • DB2 Tuning Tips for OLTP Applications (developerWorks 2002): This paper focuses on a number of DB2 tuning tips based on lessons learned from running Online Transaction Processing (OLTP)-type performance benchmarks (TPC-C, TPC-W, Trade2, etc.). Performance of a database application can be influenced by many factors. This paper concentrates on the configuration aspect of DB2 and does not take into account details with regard to capacity planning, database design, or application design with the exception of a few brief reminders.
  • DB2 SQL Tuning Tips for z/OS Developers - MyPearsonStore

    This paper focuses on a number of DB2 tuning tips based on lessons learned from running Online Transaction Processing (OLTP)-type performance benchmarks (TPC-C, TPC-W, Trade2, etc.). Performance of a database application can be influenced by many factors. This paper concentrates on the configuration aspect of DB2 and does not take into account details with regard to capacity planning, database design, or application design with the exception of a few brief reminders.

    Performance is one of the most importantfactors in any type of database system. This article focuses on anumber of DB2 performance tuning tips based on lessons learned fromrunning OLTP-type performance benchmarks (TPC-C, TPC-W, Trade2,etc.). Although performance of a database application caninfluenced by many factors, we focus on configuration rather thanon such things as capacity planning, database design, orapplication design.