DB2 Administration
DB2 has several tools available to help with administration of the subsystem environment and database objects. Some of these tools are optional and Windows-based.
DB2 Installer. Provides a GUI for installing DB2 from a workstation.
Control Center. Provides a single point of entry for controlling the entire DB2 family. Can use the Control Center to display database objects and their relationships to each other.
Visual Explain. Gives the user a graphical tool to analyze the access paths that DB2 chooses for SQL queries or statements.
Index Advisor. Assists in choosing an optimal set of indexes for table data.
DB2 Estimator. Provides a facility for estimating the performance of applications.
DB2 Installer
The DB2 Installer (see
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.
