ExitCertified Training Training with Java Solaris Red Hat IBM Symantec Siebel PeopleSoft Certified
 
Start
Training Courses and Schedules
Training Savings
IT Certification
Training Solutions
Loading
Trust Your IT Training   |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.
Email Training Course

DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs  (CG242)

Format: Instructor-Led Classroom
Other Formats:
 
 

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.
 
This Course is Certified By IBM   Flex Training Savings
 

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

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)

IBM Education Advantage Program eligibility:
 

  • Yes - IBM Education Pack - online account

 
     
    Enroll For This Class
    Enroll For This Class
    IBM DB2 Lotus Tivoli Training Class This course is taught by Certified IBM instructors.

    As your Authorized IBM Training partner, ExitCertified can put you in any IBM class in North America.

    There is a difference. Learn More
    Training Class Enrollment Ask A Question About This Training
    Code: CG242
    Format: Instructor-Led Classroom
    Length: 3 days
    Certified By: IBM
    Tuition (CAD): $contact
    Browse Similar Training Classes
    Related training classes

    Sort Schedule By: 
    No Course Dates There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
       
    Request course date Request Course On-Site
     

    DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs  (CG242) 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


      ExitCertified Training with Java Solaris Red Hat IBM Symantec Apple MySQL Siebel PeopleSoft  
      When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience.

    There is a difference. Learn from the source.    		  
    Training Contacts  
       
    Canada United States

    Vancouver Training :: 604.633.3948
    Victoria Training :: 1.866.328.3948
    Calgary Training :: 403.291.2855
    Edmonton Training :: 780.441.3948
    Regina Training :: 1.866.328.3948
    Toronto Training :: 416.487.3948
    Ottawa Training :: 613.232.3948
    Montreal Training :: 514.876.1666
    Quebec City Training :: 514.876.1666

    		Sacramento Training :: 916.669.3970
    San Francisco Training :: 415.975.3948
    San Jose Training :: 408.288.3948
    Las Vegas Training :: 1.800.803.3948
    Phoenix Training :: 602.889.9350
    Worldwide - 613.232.3948 Got Questions?
    We are happy to help. Just email us with this form and we'll get back to you shortly.
       



    (c) 2010 ExitCertified Corp. All rights reserved.


    ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:
     
    Sun Microsystems Training Oracle Training Symantec Training IBM Training Red Hat - Linux Training
    Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses, Solaris Training, Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, Fusion Middleware Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, BEA Courses, e-Business Suite Altiris Training, NetBackup Training, Veritas Training, Symantec Certification, Virus Protection Courses, IT Security Training DB2 Training, Cognos Classes, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class, CISCO Training, VMWare Training SUSE Training, RedHat Training , JBoss Training
             
    MySQL Training Apple Training Hitachi - HDS Training Project Management PMI Training  
      Apple Course, Leopard Training, Xsan Training