BMC AMI Catalog Manager for Db2® 13.x: Fundamentals Using (WBT)
BMC AMI Catalog Manager for Db2® is available under BMC AMI Database Administration for Db2® solution. This product provides an efficient gateway to Db2 catalog information. Using an interface based on the Interactive System Productivity Facility (ISPF), Catalog Manager provides interactive access to catalog information and application data with simple-to-use menus and panels.
This course provides learners with the relevant information required to manage a Db2 environment effectively. With Catalog Manager for Db2, users can quickly learn to perform database administration tasks. This administrative product prompts users for the necessary information to construct the required Db2 syntax, making it easy to execute requests without requiring extensive knowledge of SQL or utility statements. This course also covers advanced features of the product, such as utilities, utility profiles, and logs.
Major release:
BMC AMI Data 13.x
Recommended Prerequisites:
Good for:
Administrators
Course Delivery:
Web Based Training (WBT) | 3 hours
Course Modules
-
Getting Started with BMC AMI Catalog Manager for Db2®
- BMC AMI Catalog Manager overview
- Catalog Manager components
- Key features and benefits of using Catalog Manager
- Navigating Catalog Manager main menu
- Generating a list of DB2 objects
- Searching and filtering of objects
- Commands: SORT, MX, ALL, COMMAND
- Use the help facility
- Displaying the Catalog Manager options panel
- Overriding and saving Catalog Manager default options
- SQL commands
- List and view SQL table list
- Using commands DDL and HDDL
-
Deep Dive into BMC AMI Catalog Manager for Db2®
- Browsing and editing tables
- Commands: TBBROWSE and TBEDIT
- Dropping objects from the Db2 catalog
- Enabling drop recovery
- Db2 commands
- Catalog Manager specific commands
-
Advanced Features in BMC AMI Catalog Manager for Db2®
- Reporting
- Generating a list of plans
- Generating a list of packages
- Bind and Rebind plans or packages
- Displaying plan dependencies
- Introduction to Catalog Manager logs
- Maintaining different logs
- Browsing and purging log records
-
Working with Utilities
- Displaying the status of utilities
- Terminating utilities
- Generating Db2 Copy Utilities for multiple objects
- Generating multiple utilities for the same tablespace
- Introducing utility profiles
- Saving utility profiles