| Publisher | IBM | ||
|---|---|---|---|
| Format | 769.3KB PDF, requires Acrobat Rdr 5 | Date added | 01 Jan 2001 |
| Topics | OS - 400, Application Servers, Database Management | ||
| Downloads | 864 | ||
The purpose of this paper is to help you to understand the basics of identifying and tuning the performance of Structured Query Language (SQL) statements using DB2 Universal Database for AS/400 (DB2 UDB for AS/400). DB2 UDB for AS/400 provides a comprehensive set of tools for helping technical analysts tune SQL queries. Database Monitor for AS/400 (DB Monitor) is part of the set of tools OS/400 provides for assisting in SQL performance analysis since Version 3 Release 6. It is used to analyze database performance problems after SQL requests have been run.
Did you find this white paper useful?
23 out of 50 users found this white paper useful
Related white papers
On Demand Teleconference: Managing Large Objects with DB2 for z/OS
This teleconference explains how the IBM® DB2® Administration Tool and IBM DB2 Utilities Suite for z/OS® can help you manage LOBs efficiently and effectively. We'll cover the types of activities...
Translating Strategy into Action: The Balanced Scorecard
This white paper describes an integrated management approach that enables complex businesses to effectively harness their capabilities and to achieve their strategic objectives. The combination of a Balanced Scorecard approach...
Operations Navigator: Updating and Simplifying AS/400 Administration
AS/400 Operations Navigator is IBM's strategic user interface for AS/400 operations and administration. It has been created to both modernize the appearance of OS/400 and simplify the tasks required to...
Technical On Demand Teleconference: Managing large objects in a DB2 for z/OS environment - tips and techniques
This teleconference explains how the IBM® DB2® Administration Tool and IBM DB2 Utilities Suite for z/OS® can help you manage LOBs efficiently and effectively. We'll cover the types of activities...
KTM Sportmotorcycles Rides the Road to Success With AS/400e
KTM Sportmotorcycles USA, Inc., needed to make its ordering and inventory system easier to access in order to provide better service and information to dealers across the country. Revenues are...
Mazda NA Revs Dealer Support With IBM and Java Solution
Mazda North American operations (Mazda NA) has embarked on a technology strategy based on Java and IBM products to improve customer service by enhancing the company's dealer-support applications. Based on...
Moving Goods Is Part of the World's Largest Industry: Transportation
QUALCOMM Incorporated is a global leader in wireless communication products. QUALCOMM develops software and hardware solutions for hundreds of transportation companies, which typically use diverse computer platforms to monitor individual...
