MFRDB51

DATES:

1. Automatic Computing
   • Perform automated backup and table REORG with policy.
   • Use the health center and activity monitor.
2. Remote Administration
   • Enable remote administration.
   • Enable remote administration and remotely create a simple table from the command center.
3. The Governor and Audit
   • Turn on the Db2 governor for dynamic SQL.
   • Update the governor table to prevent the user from requesting too many resources during the business day.
4. Problem Determination Tools and Techniques
   • Use the Db2 Developer.
   • Turn on JDBC tracing in Developer Workbench.
5. Parallelism and SMP Enablement
   • Increase the likelihood that Db2 will use parallel processing.
   • Use two different techniques for assuring that Db2 will use parallel processing on a table.
6. Advanced Utilities
   • Improve performance, update statistics, and reorganize the data.
   • Run the following utilities: REORG, RUNSTAT, STOSTAT, COPY, and CHECK.
7. Online Table and Index Reorganization
   • Execute an Online REORG.
   • Learn how the reorganization of an object consists of the destruction of an object and its being rebuilt in a reorganized form.
   • Learn how data in the object will not be available to applications throughout the time of the REORG; an Online REORG attempts to reduce the period during which the data is unavailable.
   • Execute an Online REORG and confirm that data can still be accessed.
8. Multidimensional Clustering
   • Learn how MDC can significantly improve query performance and reduce the overhead of data maintenance operations, such as reorganization, and index maintenance operations during insert, update, and delete operations.
   • Examine how MDC is used in data warehousing and large database environments.
   • Learn how MDC can be used in OLTP: Online transaction processing environments.
   • Perform an exercise where the drawbacks associated with data clustering using a clustering index are highlighted.
9. Advanced Load
   • Code a complex load operation.
   • Given data from a mainframe system, code and execute the LOAD command to perform conversions, reorganizations of data, and extraction criteria.
10. Distributed Management
    • Learn how to setup the distributed environment.
    • Review a set of configurations using Db2 for z/OS.
11. Federated Databases
    • Examine the technology which enables clients of IBM's federated database engine to access and integrate the data and computational capabilities of a range of relational and non­relational data sources.
    • Acquire proficiency with creating a federated system by installing the federated engine and then configuring it to interact with the data sources.
    • Learn that there are several steps for adding a new data source to a federated system.
12. Replication
    • Replicate a table between two servers.
    • Given two servers, enable replication for each update to the table.

↓