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)
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