DB2 UDB Multi Partition Environment for Single Partition DBAs

IACET credits 0.0

Learn how to perform database administration using DB2 UDB in a multi partitioned environment on UNIX. If you already know how to administer a DB2 UDB database in a single partition environment, learn to administer a multi partitioned environment. This course addresses DB2 UDB V8.2.

Learn how to configure the multi partitioned environment, create and populate partitioned databases, design a database for parallel use, and use DB2 UDB utilities.

This course is intended for experienced DB2 UDB single partition DBAs who have current knowledge and experience on DB2 UDB on Linux, UNIX, or Windows.

This course addresses the product formerly known as DB2 UDB EEE.

No actual installation of DB2 UDB is performed in this workshop. Hands-on labs use a preinstalled system to exercise various administrative functions.

If you are an experienced DBA from another database product and need to learn about DB2 UDB in a multi partitioned environment, you should complete:

DB2 UDB Multi Partition Database Administration Workshop for UNIX (CF241).

course content details

	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 UDB partitioned architecture
	identify the key features that set DB2 Universal Database in a partitioned environment apart from the other members of the DB2 family

	Getting started with the DB2 UDB Graphical User Interfaces (GUI)

	describe the purpose of DB2 Administration Server (DAS)
	list the GUI tools in DB2 UDB
	explore the various ways to access the GUI tools
	use the different ways 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 Enterprise Server Edition (ESE) with Database Partitioning Feature (DPF)
	use db2_all and rah commands

	Creating databases

	describe DB2 UDB ESE with DPF data partitioning
	create a database in a DB2 UDB ESE with DPF 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 Database Managed Storage (DMS) table spaces
	use SQL functions specific to the partitioned environment
	identify catalog views that contain information about your partitioned environment

	Moving data

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

	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 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

	Monitoring and problem determination

	use 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
	installation
	installation lab
	creating databases
	creating database lab
	partitioning and database partition groups

	Day 2

	partitioning and database partition groups lab
	data placement
	creating tablespaces lab
	creating objects
	moving data - part 1
	moving data lab - import and load
	moving data - part 2
	moving data lab - partitioned load

	Day 3

	recovery
	recovery lab
	scaling the database
	scaling the database lab
	performance and application considerations
	monitoring and problem determination