Management of Db2 operations

Management of a Db2 subsystem on a daily basis requires performing a wide range of tasks. For example, you need to manage authorizations and be prepared to recover from any potential errors or problems.

When you manage a Db2 environment on a daily basis, you need to issue Db2 commands, run Db2 utilities, manage authorizations, and be prepared to recover from potential errors or problems. In addition, you probably want to take advantage of the high availability capabilities that are related to Db2, including the following capabilities:

  • You can bind application plans and packages online. By using packages, you can change and rebind smaller units. Using package versions permits binding while the applications continue to run.
  • You can define and change databases and authorizations online.
  • You can change buffer pool sizes online.
  • You can use utilities to reorganize indexes, table spaces, or partitions of indexes or table spaces.
  • You can use the data sharing functions of Db2, which enable several Db2 subsystems to process applications on shared data. Although the different subsystems share data, they appear as a single Db2 subsystem to users. Applications can be rerouted to avoid outages if one of the subsystems must be taken down for maintenance.

Several management tools are available to help you easily perform many of the tasks that are associated with daily operations of a Db2 subsystem. For more information, see Tools for managing Db2 for z/OS.