Db2 management

The following information explains how to use Db2 Admin Tool features to simplify the way you manage your Db2 environments.

Querying the Db2 system catalog
You can use Db2 Admin Tool to navigate through object information in the Db2 catalog and perform various actions on the objects.
Masks
A mask provides the ability to make context-sensitive changes to naming conventions, overwrite the current values of certain object attributes, and verify that object attributes conform to certain rules.
SQL statements
Db2 Admin Tool can issue, build, and run SQL statements.
Generating SQL to re-create a Db2 object (reverse engineering)
Before making changes to a Db2 object, you might find it useful to generate the SQL statements that are required to re-create that object. Generating this SQL ensures that the changes are applied to the current definition and that the original object definitions are available for fallback purposes.
Performance queries
This information shows you how to run performance queries by using Db2 Admin Tool and describes the different types of performance queries that Db2 Admin Tool supports.
LISTDEF and TEMPLATE
LISTDEF and TEMPLATE are Db2 utilities that provide facilities for other utilities. You can use LISTDEF to define reusable lists of objects for other utilities to process. You can use TEMPLATE to define templates for data sets that are allocated by other utilities. LISTDEF and TEMPLATE are often used together.
Altering Db2 objects
Some object changes can be implemented by using an SQL ALTER statement. Other changes require that the object be dropped and recreated.
Transferring ownership of objects from one user or role to another
When business responsibilities change, it is often necessary to change the ownership of objects from one user or role to another.
Moving tables from multi-table table spaces to UTS
You can use Db2 Admin Tool to move tables from multi-table simple or segmented table spaces, which are deprecated, to partition-by-growth universal table spaces (UTS). Moving data to supported table spaces can help you take advantage of new Db2 functionality that operates only on UTS.
Invoking Db2 Table Editor from Db2 Admin Tool
IBM® Db2 Table Editor for z/OS® is a product that makes it easy to view and modify your Db2 table data. If you have Db2 Table Editor installed, you can launch it from Db2 Admin Tool.
Details about objects in batch mode
You don't have to use the ISPF panels to generate the reports that contain details about tables, packages, and accelerated tables. Retrieving the details in batch mode can improve deployment and adoption processes.
Requesting revoke impact reports in batch
A revoke impact report helps you determine how the authorizations and database objects will be affected by revoking an authorization before you actually revoke it. You can request these reports on the Revoke object Privileges panels. You can also request these reports by using a batch job.
Migrating Db2 objects, data, views, and catalog statistics
Db2 Admin Tool enables you to migrate, or copy, Db2 object definitions, the data for the objects, views, and the catalog statistics for the objects from one Db2 subsystem to other Db2 subsystems.
Implicit LOB and XML table support
The Db2 Admin Tool ALT and MIG functions and IBM Db2 Object Comparison Tool for z/OS support changes to implicit LOB and XML table spaces.
Work statement lists (WSLs)
A work statement list, or WSL, is a collection of one or more tasks that perform basic operations, such as creating objects, granting authorizations, and running utilities.
The Batch Restart programs: ADBTEP2 and ADBTEPA
The Batch Restart program, ADBTEP2, and the Authorization Switching program, ADBTEPA, are used with work statement lists and the Alter and Migrate Db2 data functions.
Running Db2 utilities from Db2 Admin Tool
You can run Db2 utilities from Db2 Admin Tool by using the UTIL primary command or the UT, UTL, or UTIL line commands on a system catalog panel.
Db2 EXPLAIN
You can use Db2 Admin Tool to issue SQL EXPLAIN statements, which gather information about the access path that Db2 chooses to process a query.
Space management
Db2 Admin Tool manages space by displaying Db2 and VSAM statistics for Db2 page sets and by invoking functions against objects.
Change Management (CM)
The Change Management (CM) function in Db2 Admin Tool simplifies the process of recording and tracking the changes that you make to your Db2 objects. CM assigns a change ID for every change that you make to your Db2 objects and registers each change in the Change Management database.
REST services
You can use Db2 Admin Tool to create and manage your own REST services. Additionally, Db2 Admin Tool provides some REST APIs that you can use to call certain features of Db2 Admin Tool.
Determining whether applications need to be rebound
Bind avoidance is a feature of Db2 Admin Tool that helps you avoid unnecessary bind operations. Unnecessary binds can waste resources and potentially cause a Db2 access path change that might negatively affect performance.
Activating IBM Db2 AI for z/OS
IBM Db2 AI for z/OS (Db2ZAI) leverages machine learning technology to empower the Db2 for z/OS optimizer to determine the best-performing query access paths, based on your workload characteristics.
Authorization switching
Authorization switching is a facility within Db2 Admin Tool that is used to execute DDL and DCL under the authority of another user. The facility does not cover other statement types, including Db2 utility statements and DSN subcommands such as FREE PACKAGE and BIND PLAN.