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.
Managing authorizations
In Db2 Admin Tool, you can view and manage authorizations for individual Db2 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
You can use Db2 Admin Tool to build and run your SQL statements.
Generating SQL to re-create a Db2 object (reverse engineering)
Before making changes to a Db2 object, you might want 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.
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.
Viewing and updating table data
In Db2 Admin Tool, you can select, insert, update, and delete rows in your Db2 tables.
Transferring ownership of objects from one user or role to another
When business responsibilities change, you might need to change the ownership of objects from one user or role to another.
Creating or altering a trusted context
Use trusted contexts to establish trusted connections between Db2 subsystems and external entities.
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.
Invoking Db2 Log Analysis Tool from Db2 Admin Tool
You can use IBM® Db2 Log Analysis Tool for z/OS® to help with auditing, change tracking, and data recovery. This tool reports changes to table data based on Db2 log records and your specified filters (such as table, schema, and timestamp).
Invoking SQL PA from Db2 Admin Tool
Db2 SQL Performance Analyzer (SQL PA) is a query analysis tool that you can use to optimize the performance of your SQL statements for Db2. If you have SQL PA installed, you can launch it from Db2 Admin Tool.
Invoking Db2 Query Monitor from Db2 Admin Tool
IBM® Db2 Query Monitor for z/OS® is a tool that helps you monitor SQL queries across your Db2 for z/OS® environment. If you have Db2 Query Monitor installed, you can launch it directly from Db2 Admin Tool to show query activity on the subsystem or selected object.
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.
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.
Batch restart programs: ADBTEP2 and ADBTEPA
The batch restart program, ADBTEP2, and the authorization switching program, ADBTEPA, are used with work statement lists (WSLs) and the alter and migrate Db2 data functions.
Db2 utilities
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.