DB2 Universal Database Administration Workshop for Windows

M/UX
Phoenix, Arizona, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Learn how to perform database administration tasks using DB2 UDB for Linux, UNIX, and Windows. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. Use a Windows operating system during hands-on labs.

Course Materials

The course materials address DB2 UDB for Linux, UNIX, and Windows Version 8.2.

Hands-On Labs

Nine labs are included to address DB2 UDB for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 701: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration

This is an intermediate course for database administrators and other technical individuals who plan, implement, and maintain DB2 UDB for Linux, UNIX and Windows databases.


Skills Taught

--------------------------------------------------------------------------------

List and describe the components of DB2 UDB
Implement DB2 security
Perform basic administration of a DB2 database system
Define a basic DB2 recovery strategy and perform the tasks necessary to support the strategy
Describe the application development process with respect to DB2 considerations


Course outline

--------------------------------------------------------------------------------

Overview of DB2 UDB

list the DB2 family of products
identify the DB2 UDB products
describe the functions of DB2 components
compare DB2 packaging options and product requirements
list DB2 supported configurations
Getting started with DB2 UDB Graphical User Interface (GUI)

list the GUI tools in DB2 UDB
explore the various ways to access the GUI tools
use different methods to execute a command or statement in DB2 UDB
Creating databases and data placement

create DB2 databases
identify default objects that are created when a database is created
identify how table spaces may be defined to store different types of data
describe the two types of table space management
identify when each type of table space management should be used
create System Managed Storage (SMS) table spaces
create Database Managed Storage (DMS) table spaces
Create objects

describe DB2 object hierarchy
create database objects: tables, indexes, views, aliases, and schemas
alter tables and add check constraints, triggers, and referential integrity
describe Large Objects (LOB)
Moving data

describe and use the export and import utilities
describe and use the load utility
describe the functionality of the DB2 replication component
Recovery

state the three types of recovery support
explain the principles DB2 uses for its recovery/restart functions
describe the capabilities and functional requirements of DB2 logging
use the utilities to back up and recover user data and DB2’s catalog
recover data to a prior point in time
state general considerations regarding disaster recovery
prepare and implement standard recovery procedures for data recovery
Monitoring and problem determination

use error logs
identify the different monitor types
identify how to obtain a db2trc
describe the function of EXPLAIN and use this facility to assist basic analysis
identify additional commands for listing application information
Concurrency

list objects that may be locked by the database manager
discuss available lock modes and their compatibility
influence locking strategies used by the database manager
Application alternatives

prepare applications that access DB2 data for execution
use PRECOMPILE and BIND options that are appropriate for specific application requirements
describe the application alternatives available to access DB2 data or request other DB2 functions
list the benefits, and possible disadvantages, of the various interfaces
Application performance

list reasons for REBIND of application programs and execute this command
define the concept of single dimensional clustering, and determine the proper cluster sequence, if any, for DB2 tables
use RUNSTATS, REORGCHK, and REORG to enhance application performance
identify configuration parameters that impact performance of applications
Security

use DB2 access control mechanisms to implement security within the database
use group IDs to create a control hierarchy
describe privileges within a database
describe privileges required for binding and executing a package
describe the difference between explicit privileges and implicit privileges
describe the different DB2 authorization levels
Daily Agenda

Day 1

Welcome
Overview of DB2 Universal Database
Getting Started with DB2 UDB GUIs
Lab (DB2 Customization)
Creating Databases and Data Placement
Lab (Creating Databases/Tablespaces)
Day 2

Lab (Creating Databases/Tablespaces) (Continued)
Create Objects
Lab (Create Objects)
Moving Data
Lab (Moving Data)
Day 3

Lab (Moving Data) (Continued)
Recovery
Lab (Recovery)
Monitoring and Problem Determination
Concurrency
Lab (Investigating DB2 Locking)
Application Alternatives
Day 4

Lab (Preparing Applications for Execution)
Application Performance
Lab (Application Performance Tools)
Security
Lab (Securing the DB2 Environment)


...''

Phone:866-700-9811

School Address:

pSeries/AIX, CISCO, Linux, Microsoft, Professional Skills, Project Management, RedHat LINUX Enrollments 866-700-9811 (Toll Free) or 916-226-2537

CICS, iSeries/OS400, Enterprise/zSeries and WebSphere Enrollments 888-689-3326 (Toll Free) or 916-226-2511

DB2 UDB, Rational Software, and Tivoli Enrollments 866-700-9817 (Toll Free) or 916-226-2533

M/UX
9245 Laguna Springs Drive
Suite 315
Elk Grove, CA 95758 USA

Jobs & Resumes: Phoenix
Houses & Roommates: Phoenix

IBM Lotus Domino 8 Infrastructure
IBM Lotus Sametime 7.5 Infrastructure
CICS Application Programming
CICSPlex System Manager, Administration
CICS V3.2 Fundamentals
DB2 SQL Workshop
Relational Database Design
Using Rational Data Architect
DB2 9 Database Administration Workshop for Linux/UNIX/Windows
DB2 Universal Database Administration Workshop for UNIX
DB2 UDB Multi Partition Database Administration Workshop for UNIX
DB2 9 for LUW Multiple Partition DBA Workshop
DB2 UDB for z/OS and OS/390 Data Sharing Implementation
DB2 for z/OS and OS/390 Data Sharing Recovery and Restart
DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
DB2 9 for LUW Advanced Database Recovery
DB2 Stored Procedures Programming Workshop
DB2 UDB Application Programming Workshop

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.