Current dates
02.06. - 04.06.2025 - Online Ι Stuttgart
08.09. – 10.09.2025 - Online Ι München
17.11.-19.11.2025 - Online Ι München
Who is the course for
You want to know how IBM Storage 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 Storage Protect environment (TS619, TS629) and now want to go deeper.
The IBM Storage Protect and DB2 Workshop is designed for experienced administrators who want to learn the mechanics between IBM Storage 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 Storage 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 Storage Protect.
Prerequisites for participation
Experience in the administration of IBM Storage Protect databases, participation in IBM Storage 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