Tutorials

Bringing the vision of on demand business to life

• Play or download narrated demonstrations from the IBM Software recorded demonstration portfolio.
• See examples of IBM Software solutions that can help your business become more efficient, responsive, and competitive.

The best way to understand IBM Software is to see it in action.

Learn how to use various DB2 Tools for z/OS to optimize database performance, increase productivity, and improve overall time to value.

IBM DB2 Administration Tool for z/OS allows you to manage the tasks that keep DB2 performing at peak levels. A comprehensive set of functions helps DB2 personnel manage their DB2 environments efficiently and effectively. It provides in-depth catalog navigation by displaying and interpreting objects in the DB2 catalog and executing dynamic SQL statements.

The Migrate Object feature of the IBM DB2 Administration Tool for z/OS provides a comprehensive set of functions enabling administrators to migrate (or copy) DB2 object definitions, the data for the objects, and the catalog statistics for the objects from one DB2 subsystem to other DB2 subsystems. You can migrate any combination of DB2 databases, table spaces, and tables, as well as their dependent objects.

The Execute SQL feature of the IBM DB2 Administration Tool for z/OS execute SQL option allows users to execute the statements without knowing the exact syntax. Execute SQL also aids DBAs by providing guidance for the required parameters.

The IBM DB2 Object Comparison Tool maximizes system availability by helping to synchronize DB2 objects between different database environments. This tool, used in conjunction with the IBM DB2 Administration Tool, offers a function-rich object management solution. IBM DB2 Object Comparison Tool simplifies the process of comparing objects and their dependents from different sources and then synchronizing the sources, consistently keeping production databases in step with those for testing and development.

This tutorial shows how the Online Schema Evolution functionality of IBM DB2 Administration Tool for z/OS can be utilized to allow database administrators to make certain schema changes to their database objects without reducing system availability.

The Performance Query feature of the IBM DB2 Administration Tool allows administrators to select an object and then view the performance related statistics. Areas of interest such as whether or not RUNSTATS has been executed on it, and the size and efficiency of the index can be viewed. From the tool, the user can also execute DB2 utilities or alter those objects.

IBM DB2 Query Monitor gives you the ability to efficiently customize and tune your structured query language (SQL) workload and DB2 objects to ensure the effectiveness of your DB2 subsystems and improve overall performance. The tool offers you extensive choices so you can determine what monitoring information you will gather, and when.