Why take this course?
After completing this course, you will be able to
Navigate within Data Studio to complete DBA tasks such as- create and connect to databases and instances
- create and manage schemas, tables, indexes and views
- create and manage users and their access to data
- use ER diagrams and object relationships for change analysis
- create and manage table spaces and buffer pools
- move, import, export and reorganize data
- maintain and utilize database statistics
- cetup, schedule and manage jobs in the DB2 environment
1 Day : Fee - $ 697.00 (CAD) :
Multi-seat - $ 497.00 (CAD)

Sorry, no classes are currently scheduled
Audience
Current and future DB2 Database Administrators requiring a quick hands on introduction to Data Studio.Prerequisites
The student should possess, from a database administrator perspective, basic knowledge of how DB2 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
Managing Databases and Objects
- Database Management Overview
- The Database Administration Perspective
- Creating a new database
- Connecting to a database
- Adding a database in Administration Explorer
- Connection Profiles
- Managing DB2 Instances
- Navigating the database
- Creating Schemas
- Creating and altering Tables
- Creating Indexes
- Creating Views
- Creating Users
- Assigning Privileges
- Object relationships and impact analysis
- Using Entity Relationship diagrams
Database Maintenance
- Database Maintenance Overview
- Creating and managing table spaces
- Creating and managing buffer pools
- Reorganizing data for performance
- Maintaining and using database statistics
- Moving, Importing and exporting data
Job Management
- Job Management Overview
- Jobs, Components and Types
- Job creation
- Job schedule management
- Running unscheduled jobs
- Notifications and monitoring