DB2 UDB Multi Partition Database Administration Workshop for UNIX :: CF241

ExitCertified US

ExitCertified Canada English

ExitCertified Canada French



	start > courses and registration > training feature sheet

DB2 UDB Multi Partition Database Administration Workshop for UNIX

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

CF241

length.

5 days

type.

Instructor-Led

partner.

IBM

price.

$2,875

Learn how to perform database administration using IBM DB2 UDB in a partitioned environment on UNIX. These tasks include installing DB2 UDB in a partitioned environment, creating and populating databases, designing a database for parallel use, examining data for parallel queries, and using DB2 UDB utilities.

Note: Actual installation of DB2 UDB is not performed in this workshop. A preinstalled system is used to exercise various administrative functions.

course schedule

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is an intermediate course for database administrators, application developers, and consultants who plan, implement, or maintain DB2 UDB partitioned databases. This course is appropriate for students requiring knowledge of DB2 UDB Enterprise Server Edition (ESE) in a Data Partitioning Feature (DPF) environment.

prerequisites

You should complete:

	AIX 5L Basics (AU130)
	DB2 SQL Workshop (CF120)
	or be able to:
	Use basic AIX functions such as utilities, file permissions, hierarchical file system, commands, and the visual editor (vi) editor
	State the functions of the SQL and be able to construct Data Definition Language (DDL), Data Manipulation Language (DML), and authorization statements
	Discuss basic relational concepts and objects such as tables, indexes, views, and joins

skills gained

	Describe the steps to install and customize DB2 UDB in a partitioned environment
	Use Graphical User Interface (GUI) tools to administer the database
	Create objects and load data on DB2 UDB
	Implement DB2 UDB security
	Define a DB2 UDB partitioned recovery strategy and perform the tasks necessary to support the strategy
	Describe the application development process with respect to DB2 UDB considerations
	Identify how a database should be designed to take advantage of the parallel architecture
	Use DB2 UDB utilities to manage data and maintain your database

course materials

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

hands-on labs

Fourteen labs are included to address using DB2 UDB Version 8.2 for Linux, UNIX, and Windows.

certification

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

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

related courses, exams and materials

	before related training and products

	AU130 AIX 5L Basics
	CE120 SQL Workshop

course content details

	Components and concepts

	describe the kinds of business applications that use parallel databases
	describe the basic architecture of each of the hardware platforms on which parallel database may run
	define the strengths of DB2 UDB partitioned architecture
	identify the key features that set DB2 UDB in a partitioned environment apart from other members of the DB2 family

	Getting started with the DB2 UDB GUIs

	describe the purpose of DB2 UDB Administration Server (DAS)
	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
	create database objects using the GUI tools

	Installation

	identify the steps to install and customize DB2 UDB in a partitioned environment
	use db2_all and rah commands

	Creating databases

	describe DB2 UDB data partitioning
	create a database in a DB2 UDB partitioned environment
	access and update the database manager configuration file and the database configuration file
	access and update the system database directory and the local database directory
	use tools to issue commands and SQL statements

	Partitioning and database partition groups

	identify considerations when choosing a partitioning key
	describe join strategies in partitioned databases
	identify the syntax for creating database partition groups

	Data placement on the partitions

	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 Data Managed Storage (DMS) table spaces
	use SQL functions specific to the partitioned environment
	identify catalog views that contain information about your partitioned environment

	Create objects

	describe database physical directories and files
	create database objects: tables, indexes, views, and aliases
	alter tables and add check constraints, triggers, and referential integrity
	describe Large Objects (LOB)

	Moving data

	identify the different methods for inputting data, including using import, buffered inserts and the LOAD utility
	describe the process of partitioning and loading
	identify how partitioned database options on the load command can be used to automate the partitioning and load process
	identify the command to export a database table to a file

	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

	Recovery

	describe high availability and mirroring options for processor and disk backup
	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

	Scaling the database

	identify how your configuration can be scaled
	differentiate between the three options on the REDISTRIBUTE command
	troubleshoot problems that may occur during redistribution

	Performance and application concepts

	list the 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
	describe the function of EXPLAIN and use this facility to assist basic analysis

	Security

	use DB2 access control mechanisms to implement security within the database
	use group Identification Data (ID) 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

	Monitoring and problem determination

	use the DB2 UDB error logs
	identify the different monitor types
	identify how to obtain a db2trc
	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

	Daily Agenda - Day 1

	Welcome
	Components and Concepts
	Paper Lab
	GUI
	Installation
	Installation Lab
	Creating Databases

	Day 2

	Creating Database Lab
	Partitioning and Database Partition Groups
	Partitioning Keys and Database Partition Groups Lab
	Data Placement on the Partition
	Creating Table Spaces Lab
	Create Objects

	Day 3

	Creating Objects Lab
	Moving Data (Import and Load)
	Moving Data Lab - Import and Load
	Moving Data (Partitioned Load)
	Moving Data Lab - Partitioned Load
	Application Alternatives
	Application Basics Lab

	Day 4

	Recovery
	Recovery Lab
	Scaling the Database
	Scaling Lab
	Performance and Application Concepts
	Application Performance Tools Lab

	Day 5

	Security
	Security Lab
	Monitoring and Problem Determination Tools
	Concurrency
	Locking Lab

Free Chumby with IBM Training

Save on IBM Training

Organize your IT training. Contact an expert training consultant to put together the best training package for your organization.

	go to top

© 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

sun microsystems training | veritas training | linux training | mysql training | symantec training
oracle training| project management training | ibm training | netapp :: network appliance training