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
1 Day : Fee - $ 697.00 (CAD) : 
Multi-seat - $ 497.00 (CAD)
Multi-seat - $ 497.00 (CAD)Sorry, no classes are currently scheduled
Audience
Current and future DB2 Database Administrators requiring hands on training in the use of Data Studio for DB2 recoverability and monitoringPrerequisites
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