IBM Spectrum Protect and DB2 Workshop (TD-SPDB2W)

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.
 
Overview
  • Unit 1: Inside ISP
  • Unit 2: DB2 Overview
  • Unit 3: ISP and DB2
  • Unit 4: ISP / DB2 Installation and Configuration
  • Unit 5: DB2 Commands for ISP
  • Unit 6: ISP/DB2 Maintenance
  • Unit 7: Troubleshooting
  • Unit 8: Tools
  • Unit 9: Useful Info and Technotes

The labs are based on IBM Spectrum Protect 8.1.3.
Details anzeigen
Details

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: ISP and DB2
  • ISP/DB2 Instance
  • DB2 Log Handling
  • Transaction Logging
  • DB Backup and Recovery Concept

Unit 4: ISP / DB2 Installation and Configuration
  • ISP Installation / Upgrade
  • Configure the ISP Instance
  • DB2 Commands Overview
  • Start the ISP Server
  • Locking Structure

Unit 5: DB2 Commands for ISP
  • DB2 System Commands
  • DB2 Configuration (Instance Global / DB Specific)
    • db2 list db directory
    • db2 list applications
    • db2 connect to
    • db2 update
    • db2 get dbm cfg
    • db2 get authorization
    • db2 get snapshot
    • db2 terminate
    • db2 select

Unit 6: ISP/DB2 Maintenance
  • Database Reorganization
  • Parallel I/O, Memory, CPU Requirements
  • DB2 Reorg / Runstats
  • Understand Database Backup
  • Manage Database and Log Space
  • Multiple Instances
  • Fix Pack Installation

Unit 7: Troubleshooting
  • Problems
  • Recovery

Unit 8: Tools
  • ISP Operations Center
  • Cluster Technology
  • db2dart
  • d2dp

Unit 9: Useful Info and Technotes