DB2 9 Database Administration Workshop for Linux/UNIX/Windows

M/UX
Atlanta, DC, Dallas, Denver, Houston, New York, Raleigh, San Francisco, St. Louis, United States

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

Course Description:

'' Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 9 for Linux, UNIX, and Windows. New features, such as range partitioning, data row compression, and pureXML (native XML storage) will be introduced. Use a Linux operating system during hands-on labs.

This is an intermediate course for system administrators, database administrators and other technical personnel involved in planning, implementing, and maintaining DB2 for Linux, UNIX and Windows databases.


Skills Taught

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

After completing this course, you should be able to:

Administer a DB2 database system using commands and GUI tools
Implement DB2 security
Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles
Implement a given logical database design using DB2 to support integrity and concurrency requirements
List and describe the components of DB2
Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
Describe the application development process with respect to DB2 considerations
Use autonomic features of DB2


Course outline

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

Overview of DB2 9 on Linux, UNIX and Windows

Contrast the DB2 Family of products
Identify the DB2 Products
Describe the functions of DB2 components
Explore installation and parameters
Command Line Processor (CLP) and GUI usage

Use the Command Line Processor
Explore the GUI environment
Describe the DAS role with GUI tools
The DB2 environment

Specify the key features of an Instance
Create and drop an Instance
Use db2start and db2stop
Distinguish between types of configuration
Describe and modify the Database Manager Configuration
Creating databases and data placement

Review specifics of creating a database
Explore the System Catalog tables and views
Compare DMS versus SMS table spaces
Describe how to setup and manage a DB2 database with Automatic Storage enabled
Differentiate between table spaces, containers, extents, and pages
Define table spaces
Use the get snapshot for tablespaces command to display table space statistics
Explore Database configuration parameters
Creating database objects

List DB2 object hierarchy and physical directories and files
Create the following objects: Schema, Table, View, Alias, Index
Explore the use of table partitioning
Review the use of Temporary Tables
Explore the use and implementation of Check Constraints, Referential Integrity and Triggers
Exploring the need for and the use of Large Objects
Recognize XML and its native store as critical infrastructure for emerging technologies
Moving data

Discuss the INSERT statement and recognize its limitations
Explain the differences between IMPORT and LOAD
Explain the EXPORT, IMPORT, and LOAD syntax
Create and use Exception Tables and Dump-Files
Distinguish and resolve Table States: Load Pending and Set Integrity Pending
Use the SET INTEGRITY command
Discuss the db2move and db2look commands
Backup and recovery

Describe the major principles and methods for backup and recovery
State the three types of recovery used by DB2
Explain the importance of logging for backup and recovery
Describe how data logging takes place, including circular logging and archival logging
Use the BACKUP, RESTORE, and ROLLFORWARD commands
Perform a table space backup and recovery
Restore a database to the end of logs or to a point-in-time
Discuss the configuration parameters and the recovery history file and use these to handle various backup and recovery scenarios
Locking and concurrency

Explain why locking is needed
List objects that can be locked
Describe and discuss the various lock modes and their compatibility
Explain four different levels of data protection
Set isolation level and lock time out for current activity
Explain lock conversion and escalation
Describe the situation that causes deadlocks
Problem determination

Collect information for problem analysis and resolution
Use error logs for basic problem analysis
Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor, Health Monitor
Describe the function of EXPLAIN and use this facility to assist basic analysis
Use a series of basic commands to better work with connections and sessions
Retrieve statistics and other information from a running DB2 instance
Application issues and performance

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 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
Work with the Explain facility
Security

Use DB2 access control mechanisms to implement security within the database
Use group IDs to create a control hierarchy
Describe Label Based Access Control (LBAC)
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
Agenda

Day 1

Welcome
Unit 1 - Overview of DB2 9 on Linux, UNIX and Windows
Lab 1 (Starting your lab environment)
Unit 2 - Command Line Processor (CLP) and GUI usage
Lab 2 (DB2 customization)
Unit 3 - The DB2 environment
Lab 3 (DB2 environment)
Day 2

Unit 4 - Creating databases and data placement
Lab 4 (Creating databases and data placement)
Unit 5 - Creating database objects
Lab 5 (Create objects)
Unit 6 - Moving data
Day 3

Lab 6 (Moving data)
Unit 7 - Backup and recovery
Lab 7 (Backup and recovery)
Unit 8 - Locking and concurrency
Lab 8 (Investigating DB2 locking)
Day 4

Unit 9 - Problem determination
Lab 9 (Problem determination)
Unit 10 - Application issues and performance
Lab 10 (Application performance)
Unit 11 - Security
Lab 11 (Security)


...''

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: Atlanta, DC, Dallas, Denver, Houston, New York, Raleigh, San Francisco, St. Louis
Houses & Roommates: Atlanta, DC, Dallas, Denver, Houston, New York, Raleigh, San Francisco, St. Louis

IBM Lotus Domino Designer 8
IBM Lotus Domino 8 Administration
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 Universal Database Administration Workshop for 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

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.