About this Course

Are you a new DBA? Changing from vendor utilities to DB2 utilities? Need an in depth knowledge of how to implement and manage DB2 utilities? Then this course is for you. We’ll guide you through the development of utility procedures, utility management and help you build best practices.

Audience Profile

Database Administrators, System Administrators and experienced Application personnel who will be working with the IBM DB2 utilities.

Prerequisites

Experience in creating or working with DB2 Database objects.

Course Outline

1. DB2 Utility Suite Overview

• Utility grouping
• LISTDEF & TEMPLATEs
• Dataset requirements
• Related Commands

2. Loading Databases

• Build and execute LOAD Utility
• Make Informed choices or keyword options
• Interpret Utility statuses and messages
• Working with special purpose table spaces

3. Check Utility

• Data Integrity validation using CHECK DATA
• LOB validation
• Index validation

4. Preparing for Recovery

• Identify critical resources required for Recover
• Build and execute the following utlities: COPY, MERGECOPY, COPYTOCOPY, QUIESCE, MODIFY
• Establish Backup procedure to match service level agreements
• Establish consistency points to facilitate Recovery

5. Recovery

• Backup and Recovery Procedures and Choices
• What happens during Recovery
• Implementing Recovery Cycles
• Recover Database Objects to current or prior points in time
• Recovery from various files

6. RUNSTATS & STATISTICS

• Build and execurte RUNSTATS Utility
• Identify critical statistical criteria
• Choose appropriate statistics to gather
• Profiles and Autonomic Stats
• MODIFY STATISTICS Utility
• STOSPACE Utility

7. REORG Utility

• Overview and options
• Build & execute REORG for optimum concurrency
• On-line REORG Alterable options
• Incoporate inline COPY & STATS in your REORG

8. UNLOAD, Service Aids and Sample Applications

• Unload Utility for data movement
• IBM Stand-Alone Service Aids
• IBM supplied Sampple Applications
• IBM supplied Stored Procedures