TrainingIBM Spectrum Protect and DB2 Workshop (TD-ISPDB2W) (8.1.5)

Unit 1: Inside ISP

• Historical background
• Benefits of DB2 as TSM /ISP database
• Administration

Unit 2: DB2 Overview

• DB2 History
• DB2 Structure
• DB2 Access Structure
• DB2 Settings
• DB2 Processes and Threads

Unit 3: TSM / ISP with DB2

• DB2 Instance
• Transaction Logging
• DB Backup and Recovery Concept

Unit 4: TSM / ISP Installation and Configuration

• TSM V6.x Installation
• TSM / ISP V7.x/V8.x Installation / Upgrade
• Configure the DB2 Instance
• DB2 Commands
• Start the TSM / ISP Server
• Locking Structure

Unit 5: DB2 Commands for TSM / ISP

• DB2 System Commands
• DB2 Configuration Commands

Unit 6: DB2 Maintenance

• Database Space Allocation
• Parallel I/O, Memory, CPU Requirements
• Understand Database Backup
• Manage the Database and Log Space
• DB2 Maintenance including DB2 Reorganization
• Multiple Instances
• Fix Pack Installation

Unit 7: Tablespace Conversion with Utility

• ISP Tablespace Conversion
• Migration to another Operating System

Unit 8: Troubleshooting

• Log Files
• Installation/Upgrade Problems
• Problem Situations
• DB Recovery and DRM

Unit 9: Tools

• ODBC
• Cluster Technology
• Monitoring Tools

Unit 10:

• Useful Info and Technotes