Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs
 
 
 
 
ibm certified training   this course works with savings passes
 
code. CG242   length. 3 days
type. Instructor-Led   partner. IBM
price.
$1,950  
 
 
This course teaches you how to perform database administration tasks using IBM DB2 Enterprise 9 with the Database Partitioning Feature (DPF). This course provides a fast path to DB2 Enterprise 9 partitioned database administration skills for experienced DB2 single partition database administrators. These tasks include customization for the DB2 Enterprise 9 with DPF system, creating and populating partitioned databases, designing a database for parallel use, and using partitioned DB2 utilities. There is no actual installation of DB2 Enterprise software in this workshop. A DB2 for Linux system is used to exercise various administrative functions.
 
course schedule  
 
Chicago, IL apr.6.2009 - apr.8.2009 register register
     
   
Request another training Date Request onsite training
 
who can benefit
  
 
This is intermediate course for DB2 for Linux, UNIX and Windows single partition experienced database administrators involved in planning, implementing, or maintaining DB2 multi partitioned DPF databases.
 
prerequisites
  
 
Before taking this course, you should be able to:

Use basic UNIX functions such as utilities, file permissions, hierarchical file system, commands, and the vi editor.
Administer a DB2 for Linux, UNIX and Windows single partition database.
These skills can be developed by taking on of the following courses:
DB2 9 Database Administration Workshop for Linux (CF20)
DB2 9 Database Administration Workshop for UNIX (CF21)
DB2 9 Database Administration Workshop for Windows (CF23)
DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CF48)
 
skills gained
  
 
After completing this course, you should be able to:

Describe the steps to install and customize DB2 Enterprise 9 in a DPF partitioned environment
Load data on DB2 Enterprise 9 in a partitioned environment
Define a DB2 DPF partitioned recovery strategy and perform the tasks necessary to support the strategy
Identify how a database should be designed to take advantage of the parallel architecture
Use the DB2 utilities to manage data and maintain your DPF partitioned database
 
ibm education advantage program eligibility:
  
 

Yes - IBM Education Pack - online account


 
course content details  
 


  DB2 DPF Partitioned Database Components and Concepts

Identify the kinds of business applications that use parallel databases
Describe the basic architecture of each of the hardware platforms on which parallel databases may run
Define the strengths of the DB2 DPF partitioned architecture
Identify the key features that set DB2 in a DPF partitioned environment apart from other members of the DB2 family




  Getting Started with DB2

Describe the purpose of DAS




  Installation

Identify the steps to install and customize DB2 in a partitioned environment
Use db2_all and rah commands




  Creating a Partitioned DB2 Database

Describe DB2 database partitioning
Create a database in a DB2 partitioned environment with or without Automatic Storage enabled
List the three types of Storage Management for table spaces
Describe the three default system table spaces
Access and update the database manager configuration file and the database configuration files
Access and update the system database directory and list the local database directory
Use tools to issue commands and SQL statements




  Partitioning and Database Partition Groups

Identify considerations when choosing a distribution key
Describe join strategies in partitioned databases
Identify the syntax for creating database partition groups




  Data Placement on the Partitions

List the advantages and disadvantages for each type of table space management
Create SMS table spaces
Create DMS tablespaces
Create Automatic Storage managed table spaces
Use the GET SNAPSHOT commands and db2pd commands to check table space status
Use SQL functions specific to the partitioned environment
Identify catalog views that contain information about your partitioned environment




  Moving Data

Utilize the EXPORT Utility to extract data from a DB2 database
Identify the different methods for inputting data, including the Import Utility, using buffered and unbuffered SQL INSERT and the LOAD Utility
Describe the process of partitioning and loading data
Identify how the partitioned database options on the LOAD command can be used to control the data partitioning and load processing




  Partitioned Database Backup and Recovery

Describe the three types of recovery support provided by DB2
Explain the principles DB2 uses for its recovery/restart functions
Describe the configuration options for DB2 logging and explain the differences between circular and archive logs
Use the BACKUP, RESTORE and ROLLFORWARD commands to back up and recover a DPF partitioned database
Recover the database to a prior point in time using the RECOVER DATABASE command
State general considerations regarding disaster recovery and implementation of a server cluster for high availability




  Scaling the Database

Identify how the partitioned database configuration can be scaled by adding new database partitions
Differentiate between the three options on the REDISTRIBUTE command
Utilize the REDISTRIBUTE command to add or remove database partitions from a database partition group
Troubleshoot problems that may occur during redistribution




  Database and Application Performance

Describe the steps used by the DB2 Optimizer to generate access plans
List the major influences for SQL optimization, including Catalog statistics, database memory configuration, optimization class selection and database partition groups
Utilize the RUNSTATS utility to collect detailed table and index statistics
Explain the major goals for table and index reorganization
Use the REORGCHK report to plan effective use of the REORG utility
Describe the use of the DB2 explain tools to analyze access strategies for SQL statements




  Monitoring and Problem Determination

Use error logs
Identify the different monitor types
Identify how to use the independent trace facility (db2trc)
Use the dp2pd problem determination tool to obtain statistics from a running instance
Identify additional commands for listing application information




  Locks and Concurrency

Locks and Concurrency




  Agenda - Day 1

Welcome
DB2 DPF Partitioned Database Components and Concepts
Getting Started with DB2
Installation
Installation Lab
Creating a Partitioned Database
Creating Database Lab
Partitioning and Database Partition Groups
Partitioning and Database Partition Groups Lab




  Day 2

Data Placement on the Partitions
Creating Tablespaces Lab
Create Objects Lab
Moving Data - Part 1
Moving Data Lab - Import and Load
Moving Data - Part 2
Moving Data Lab - Partitioned Load




  Day 3

Partitioned Database Backup and Recovery
Recovery Lab
Scaling the Database
Scaling the Database Lab
Database and Application Performance
Database and Application Performance Lab
Monitoring and Problem Determination
Locks and Concurrency
Monitoring and Problem Determination Lab



 
Free Chumby with IBM Training

Save on IBM Training



find a course
 
phone us
 
view course schedule





Rock solid authorized training. Search all courses now...

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware