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 graphical user interface 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 data base objects and their relationships to each other.

  • Visual Explain

    • Gives the user a graphical tool to analyze the access paths that DB2 chooses for your 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 ...

Get DB2® Universal Database for OS/390® Version 7.1 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.

Start your free trial