Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

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

Catégorie: Formation

Information Management - DB2

Format: Formation en classe avec formateur

Autres formats:

This course replaced CG242. This is the classroom version of the Instructor-led online course 3L250

This course teaches you how to perform database administration tasks using IBM DB2 Enterprise 9 with the Database Partitioning Feature. 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 Materials

The course materials address DB2 9.7 for Linux, UNIX, and Windows.

Hands-On Labs

Eleven labs are included to address DB2 9.7 for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration.

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.




	Compétences acquises
	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




	Qui peut en profiter
	This intermediate course is for DB2 for Linux, UNIX and Windows single partition experienced database administrators involved in planning, implementing, or maintaining DB2 multi partitioned DPF databases.




	Préalables
	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




	Abstract
	IBM Education Advantage Program Eligibility Yes - IBM Education Pack - Online account

Ce cours est donnÃ© par des formateurs certifiÃ©s IBM.

Ã€ titre de partenaire en formation agrÃ©Ã©e , ExitCertified peut vous inscrire Ã nâ€™importe quel cours en AmÃ©rique du Nord.

Il y a une diffÃ©rence. DÃ©couvrez-la

Code:	CL250
Format:	Formation en classe avec formateur

Durée:	3 days
Certifié par:	IBM

Frais d’inscription (CAD): $contact

TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011


Towson/Baltimore, MD	Sep.4 - Sep.6.2012

1 Dates Offered

DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs (CL250) Contenu détaillé

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

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

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

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/ibm-training/CL250.html

Message:


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI

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

Compétences acquises

Qui peut en profiter

Préalables

Abstract

Formation de IBM (2375 cours)

Formation de Information Management - DB2 (103 cours)

Formation de DB2 for Linux, UNIX and Windows (26 cours)

DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs (CL250) Contenu détaillé