DB2 Recoverability and Monitoring with Data Studio

Why take this course?

After completing this course, you will be able to
Navigate within Data Studio to complete DBA tasks such as
  • configure circular and archival logs
  • manage database backups
  • use backups and logs to recover databases and transactions
  • monitor DB2 health
  • implement monitoring alerts and notifications
  • manage database availability and application connections
  • monitor table space and utility status
DB1911 Duration - 1 Day : Fee - $ 697.00 (CAD)
Wed Sep 9, 2015
Contact us for a date or location
Students who complete this course will learn how to use IBM's Data Studio to perform DBA tasks in log management, backup and recovery as well database monitoring.
Current and future DB2 Database Administrators requiring hands on training in the use of Data Studio for DB2 recoverability and monitoring
The student should possess, from a database administrator perspective, basic knowledge of how DB2 operates and implements the relational model.

Major topics covered

Data Studio Overview

  • General concepts and layout
  • Navigation
  • Perspectives and views
  • Workspaces and setting
  • The Web Console
  • The Task Launcher

Database recoverability

  • Recovery and logging overview
  • Configuring logs
  • Database Backups
  • Database Restores
  • Applying logs to roll forward transactions
  • Automatic maintenance options

Monitoring database health

  • Monitoring overview
  • Identifying databases to monitor
  • Understanding the Health Summary page
  • Alert details
  • Configuring alerts, notifications and comments
  • Managing application connections
  • Current table space and utilities status
  • Managing database availability and connections