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

Online / Stuttgart

Function and analysis of the internal Spectrum Protect database.
We offer this course with our partner Tech Data.

*Editor's note: Since version 8.1.19, the product is called "IBM Storage Protect", but is identical to IBM Spectrum Protect. The course offered here uses a version that still officially runs under the name IBM Spectrum Protect.

Current dates

20.11. - 22.11.2023 - Online Ι Trainer: Andreas Wagener

28.02. - 01.03.2024 - Online Ι Stuttgart

22.05. - 24.05.2024 - Online

10.06. - 12.06.2024 - Online 

16.09. – 18.09.2024 - Online Ι Stuttgart    

21.10. - 23.10.2024 - Online Ι Stuttgart


Dates and registration

Who is the course for

You want to know how IBM Spectrum Protect's internal database works and how to use this knowledge to troubleshoot at the DB2 level. You have completed the advanced courses in the IBM Spectrum Protect environment (TS619, TS629) and now want to go deeper.
The IBM Spectrum Protect and DB2 Workshop is designed for experienced administrators who want to learn the mechanics between IBM Spectrum Protect and its database.

What you will learn in this course

In this 3-day workshop you will learn about the internal structures of an IBM Spectrum Protect instance, which can be found completely in the DB2 database. Together we will look at the current performance or running processes on the database level.
In practical exercises on Windows or Linux systems you can test the various query options and study the behavior of the database in interaction with IBM Spectrum Protect.

Prerequisites for participation

Experience in the administration of IBM Spectrum Protect databases, participation in IBM Spectrum Protect courses TS619 and TS629.

Unit 1: A look at ISP

  • Historical background
  • Advantages 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
  • Configuring the DB2 instance
  • DB2 Commands
  • Starting the TSM / ISP Server
  • Lock structure


Unit 5: DB2 Commands for TSM / ISP

  • DB2 System Commands
  • DB2 configuration commands


Unit 6: DB2 Maintenance

  • Allocation of database space
  • Parallel I/O, Memory, CPU requirements
  • Understanding database backup
  • Managing 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
  • Problems during installation/upgrade
  • 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.

The following courses might also interest you...