DB2 Objects and Maintenance 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
  • 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
Contact us to arrange your preferred location and date
Students who complete this course will learn how to use IBM's Data Studio to manage common database objects as well as perform standard maintenance activities as a DB2 DBA.
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