DB2 Connect Version 10.5 for Linux, UNIX, and Windows

Tuning

DB2 Connect performance considerations
Performance is the way a computer system behaves given a particular workload. It is affected by the available resources and how they are used and shared. If you want to improve performance, you must first decide what you mean by performance.
Application design
When you create an application, you can improve performance in several ways. For example, consider using compound SQL and stored procedures, grouping related database requests into one database request, refining the predicate logic, implementing data blocking and tuning your dynamic SQL. This section is also relevant for applications using embedded SQL.
Connection management
DB2 Connect server tuning
Various parameters in the database manager configuration file can be used to tune DB2 Connect™.
CLI/ODBC application performance tuning
CLI/ODBC is an SQL application programming interface that can be called by your database applications. CLI functions invoke DB2 stored procedures which, in turn, access the system catalog tables. If CLI/ODBC applications are encountering performance problems, consider tuning their behaviour with CLI/ODBC keywords.