DB2 Administration


Several DB2 tools are available to help with administration of the subsystem environment and database objects. Some of these tools are optional and Windows based. Following are some of the major tools, especially those that can be used with DB2 for z/OS.

  • DB2 Customization Center provides a workstation-based graphical user interface (GUI) for the installation and migration of DB2.

  • DB2 Administration Client provides a workstation-based tool for managing and administering databases.

  • Visual Explain provides the user with a graphical tool to analyze the access paths that DB2 chooses for SQL queries or statements.

  • DB2 Estimator provides a facility for estimating the performance of applications and SQL.

DB2 Customization Center

The z/OS Managed System Infrastructure for Setup (msys for Setup) is a framework that various z/OS products use to simplify their setup. The DB2 Customization Center uses this framework and simplifies the task of installing or migrating a DB2 subsystem in a z/OS environment. A workstation interface is used for the tasks. A set of wizards guides you through setting the parameters (DSNZPARMs) and provides defaults and recommendations wherever possible. The appropriate setup and configuration can then be submitted. The workstation interface can be used to view or update subsystem parameters and other information.

The DB2 Customization Center can be used to complete such tasks as

  • Installing a new DB2 version 8 subsystem

  • Cloning a DB2 version 8 subsystem

  • Adding a new data sharing member to an existing version 8 data sharing group

  • Migrating a subsystem from version 7 to version 8

  • Turning off new-function mode or falling back to version 7

  • Remigrating an existing subsystem or data sharing member to version 8 compati- bility mode

  • Modifying subsystem parameter values for an existing version 8 subsystem or data sharing member

DB2 Administration Client

This client enables workstations from a variety of platforms to access and administer DB2 databases through the Command Center, the Control Center, or the Configuration Assistant. The Control Center supports the entire DB2 family, including z/OS, and can be used as a single point of entry for controlling the entire DB2 family. You can use the Control Center to display database objects and their relationships to one another. The Control Center's GUI allows you to easily manage local and remote servers from a single workstation. You can also launch other tools, such as DB2 Warehouse Center, DB2 Visual Explain, Command Center, Development Center, Information Center, Configuration Assistant, and more.

Visual Explain

DB2 Visual Explain lets you graphically analyze the access paths that DB2 chooses for your SQL queries or statements. The graph of the access path is displayed on a Windows workstation, eliminating the need to manually interpret the plan table output. This tool offers suggestions for improving the performance of your SQL queries or statements. You can change an SQL statement and dynamically explain it to see whether the access path is improved by the change. You can also use this tool to browse through the current values of subsystem parameters.

Visual Explain issues DRDA queries through a DB2 client on the workstation to get needed information. DB2 Visual Explain helps database administrators and application developers to

  • Graphically see the access path for a given SQL statement

  • View statement cost in milliseconds and service units

  • Tune SQL statements for better performance

  • View the current values for subsystem parameters

  • View catalog statistics for tables and indexes

  • Generate custom reports

DB2 Estimator

DB2 Estimator is an easy-to-use, standalone tool for estimating the performance of DB2 z/OS and OS/390 applications. It can be run on PCs that support Microsoft Windows (98/NT/2000/XP). It supports simple table sizing up to a detailed performance analysis of an entire DB2 application. DB2 Estimator saves time and lowers costs by allowing you to investigate the impact of new or modified applications on your production system before you implement them. DB2 Estimator provides such information as

  • Elapsed time for an SQL statement that fetches N rows

  • Processor resources used during an N-way join

  • Impact of adding and dropping an index from a table

  • System support ability for an anticipated increase in workload

  • Effects of doubling processor resources on transaction response time

  • Storage required for a new table and its indexes

  • Index support for predicates

  • Effect on performance of doubling table size

  • Ability of the application to complete within a batch window

  • Execution time of utility jobs

  • Effects of data compression

  • Effects of data sharing

  • Effects of triggers

DB2 Estimator lets you change your definitions easily to help you evaluate alternative designs. By comparing the cost and performance of these designs, you can determine which design provides the optimum cost/performance ratio before you invest valuable time and resources coding your application or creating a real database. DB2 Estimator helps you build more efficient databases by building a model of your system, based on your data knowledge, with reasonable access paths for your SQL statements. If DB2 information is available through DB2 Explain and/or DB2 Performance Monitor, you can tune the model by overriding the model assumptions.

You can also import table, index, and SQL statements from your DB2 database to DB2 Estimator and then modify them to suit your modeling requirements.



DB2 for z. OS Version 8 DBA Certification Guide
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
Year: 2003
Pages: 175
Authors: Susan Lawson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net