Application Servers White Papers
Application Performance Tuning for DB2 OS/390 and z/OS
Overview
Databases are at the foundation of a business computing architecture that often includes web servers, application servers, client workstations, application logic, networks, and other
components. The database acts as the data server, and can quickly turn into an application bottleneck if a problem occurs. In many cases, newly developed applications pass quality assurance tests, but go on to fail in production because of scalability problems. Poorly written Structured Query Language (SQL)—the language used by the applications to retrieve and store data in a database—frequently causes this to happen.
Like other databases, IBM DB2 is negatively affected by poor application SQL. Bad SQL—like bad grammar—will still communicate the required message, but takes longer to interpret and understand, thus resulting in a much slower response. Application SQL must be tuned to
optimize performance and maximize the return on an often-significant investment in business technology.
| Publisher | Quest Software | File Format | PDF, requires Acrobat Rdr 5 |
|---|---|---|---|
| Date Published | January 2001 | Downloads | 24 |
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful?
White Paper RSS
Download
Register
