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

Online

Function and analysis of the internal Spectrum Protect database.

We offer this course with our partner Tech Data.

Current dates

2023

06.03. - 08.03.2023 - Online | This course is guaranteed! Trainer: Andreas Wagener

12.06. - 14.06.2023 - Online

14.06. - 16.06.2023 - Online

06.09. - 08.09.2023 - Online

18.09. - 20.09.2023 - Online

20.11. - 22.11.2023 - Online

 

Dates and registration

Overview

In this course you will learn advanced Tivoli Storage Manager (TSM) / IBM Spectrum Protect (ISP) operations. You will discuss particular situations with TSM / ISP and DB2 and learn to handle them.

  • Unit 1: Inside Tivoli Storage Manager / IBM Spectrum Protect
  • Unit 2: DB2 Overview
  • Unit 3: TSM / ISP with DB2
  • Unit 4: TSM / ISP Installation and Configuration
  • Unit 5: DB2 Commands for TSM / ISP
  • Unit 6: DB2 Maintenance
  • Unit 7: Table Space Conversion with Utility
  • Unit 8: Troubleshooting
  • Unit 9: Tools
  • Unit 10: Useful Info and Technotes

The labs are based on IBM Spectrum Protect 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

Our workshop language is German. If you are interested in an English training, please send us an email.