Summary
Understanding the DB2 database environment is an important part of any database administrator's job. To gain this understanding, there are various facilities that can be used. There are several ways to analyze the database activity. Graphical monitoring tools, such as DB2PM and Visual Explain, can be used with DB2 Universal Database.
The DB2 optimizer is one of the most advanced in the relational database industry. The optimizer generates an access plan during query compilation. Access paths are stored in the system catalog tables for static SQL applications. Access paths for dynamic SQL statements are generated at query execution time and stored in memory.
To gain an understanding of the access path (strategy) chosen by the DB2 optimizer, ...
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
