DB2 UDB for z/OS V8 Database Administration Workshop

start > courses and registration > training feature sheet

DB2 UDB for z/OS V8 Database Administration Workshop - Part 2

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

code.

CF841

length.

5 days

type.

Instructor-Led

partner.

IBM

price.

$2,875

IACET credits 4.0

This course is a continuation of DB2 UDB for z/OS Database Administration Workshop - Part 1 (CF831). Learn how to perform additional database administration tasks. Also, examine several of the topics introduced in CF831 in much more depth.

Phoenix, AZ	sep.22.2008 - sep.26.2008	register
Santa Clara, CA	sep.22.2008 - sep.26.2008	register
El Segundo/Los Angeles, CA	sep.22.2008 - sep.26.2008	register
Sacramento/Elk Grove, CA	sep.22.2008 - sep.26.2008	register
Englewood/Denver, CO	sep.22.2008 - sep.26.2008	register
Miami, FL	jul.21.2008 - jul.25.2008	register
Chicago, IL	oct.20.2008 - oct.24.2008	register
Irving/Dallas, TX	jun.2.2008 - jun.6.2008	register
Bellevue/Seattle, WA	sep.22.2008 - sep.26.2008	register

who can benefit

This is an intermediate course for DB2 UDB for z/OS and OS/390 database administrators who have the basic skills required to administer a DB2 database and who want to extend their skills.

prerequisites

You should complete:

	DB2 UDB for z/OS Database Administration Workshop - Part 1 (CF831)
	OR have equivalent experience

skills gained

	Execute program preparation steps including resolving common problems, defining collections and packages, and versioning of packages
	Alter table characteristics, such as data types of columns, and identify the impact of making such changes
	Alter indexes to add columns or to change the varying length or clustering characteristics of the index and identify the impact of making such changes
	React to the Advisory Reorg Database Exception Table state
	Make appropriate decisions to successfully handle table space versions
	Use parallel index build with the LOAD, REORG and REBUILD INDEX utilities
	Load partitions in parallel
	Determine the appropriate LOAD options to use while considering concurrency and performance requirements
	Choose appropriate options with REORG and UNLOAD to achieve optimal performance and availability
	Given the usage of the data, determine an appropriate option for dealing with the need for adding partitions or rebalancing data partitions
	Provide appropriate LISTDEF, TEMPLATE, and OPTIONS utility control statements for use in DB2 utilities
	Determine the applicability and implement user defined data types, user defined functions, stored procedures, triggers, and large objects

course materials

The course materials cover DB2 UDB for z/OS Version 8.

hands-on labs

Nine labs are included to address database administration using DB2 UDB for z/OS Version 8.

certification

Prepare for IBM Certification Test 702, IBM DB2 UDB Version 8 for z/OS Database Administration.

ibm education advantage program eligibility:

	Yes - IBM Education Card
	Yes - IBM Education Pack
	Yes - IBM Corporate Education Pass
	Yes - IBM Education Pack - online account

skill level

Intermediate

related courses, exams and materials

	other related training and products

CF891 Application Data Recovery for DB2 UDB for z/OS & OS/390

	before related training and products

	CE030 DB2 Family Fundamentals
	CE120 SQL Workshop
	CF830 DB2 UDB for z/OS and OS/390 V7 Database Administration Workshop - Part 1
	CF831 DB2 UDB for z/OS V8 Database Administration Workshop - Part 1

course content details

	Program preparation and use of packages

	successfully go through the program preparation steps and execute programs in DB2 environment using the Time Sharing Option (TSO) attachment facility
	understand how to resolve some of the most commonly occurring problems, for example SQL error -805
	understand the importance of collections and packages
	understand how to access different tables and views at execution time without changing the program
	handle mirror tables
	understand package versioning

	Online schema enhancements

	understand how to change data types and lengths of columns
	understand how to alter or add an index to have true VARCHAR columns
	understand how to unbundle partitioning and clustering

	LOAD and REBUILD INDEX performance and availability

evaluate how these enhancements can be used in your installation

	REORG and UNLOAD performance and availability

	apply the performance features for REORG: SORTDATA, NOSYSREC, SORTKEYS
	use the availability features for REORG: read-only online REORG, that is, SHRLEVEL REFERENCE; full online REORG, that is, SHRLEVEL CHANGE
	establish inline statistics during REORG
	unload data from table spaces and image copy data sets

	Partition management

	understand how to add partitions
	understand how to rotate partitions
	understand how to rebalance partitions

	Generic utility jobs

	provide reusable list definitions for use by DB2 utilities
	use list definitions in utility control statements and understand how they expand
	describe the concept and working of templates replacing utility Dataset Definition (DD) statements
	use templates in utility jobs to simplify Job Control Language (JCL)
	use templates together with list definitions
	use the OPTIONS utility control statement to control execution parameters for utility jobs

	User-defined Distinct Types (UDT), User-Defined Functions (UDF) and stored procedures

	identify the need for schemas, define schemas, and use schemas
	use schemas in the PATH BIND option
	identify the need for UDTs, define UDTs, and use UDTs
	differentiate between external scalar functions, external table functions, SQL scalar functions, and sourced functions
	determine which UDF or stored procedure is invoked, given the invocation statement and existing functions or procedures
	identify privileges associated with schemas, UDTs, and stored procedures
	differentiate between the capabilities of UDFs and stored procedures
	define a UDF
	define a stored procedure

	Triggers

	identify benefits of triggers
	list characteristics of BEFORE and AFTER triggers and functions that can be performed by them
	specify trigger granularity
	define a trigger
	use transition variables and transition tables within triggers
	identify privileges associated with trigger definition
	describe the trigger package

	Large objects

	identify the data types of large objects
	explain the relationship between the base table and the auxiliary table
	define large objects
	identify the use of ROWIDs with large objects
	list alternative ways to process large objects within applications
	evaluate locking considerations when processing large objects
	identify considerations when loading tables with large objects

	Performance-related topics

	understand why performance is important
	evaluate how table implementation impacts performance
	understand the basics of the queuing theory
	cool hot spots

	Extensive machine lab exercises