Administering Db2
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.
Where to find PDF format and online content
The following table shows where to find the PDF format and online content from this section of the Db2 for z/OS® product documentation.
PDF book format documentation | Online product documentation locations |
---|---|
Administration Guide | |
Data Sharing: Planning and Administration | |
Internationalization Guide | |
REST Services | |
Text Search for Db2 for z/OS Installation, Administration, and Reference | |
Spatial Support for Db2 for z/OS User's Guide and Reference | |
SQL Tuning Services Installation and Getting Started Guide |