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 1

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

code.

CF831

length.

5 days

type.

Instructor-Led

partner.

IBM

price.

$2,875

IACET credits 4.0

Learn how to physically implement a logical database design in DB2. Learn about DB2 data management, DB2 catalog tables, the bind process, database utilities, such as LOAD and REORG, and security considerations.

Phoenix, AZ	jun.16.2008 - jun.20.2008	register
El Segundo/Los Angeles, CA	jun.16.2008 - jun.20.2008	register
Sacramento/Elk Grove, CA	jun.16.2008 - jun.20.2008	register
San Francisco, CA	jun.16.2008 - jun.20.2008	register
Sacramento/Elk Grove, CA	sep.15.2008 - sep.19.2008	register
El Segundo/Los Angeles, CA	sep.15.2008 - sep.19.2008	register
San Francisco, CA	sep.15.2008 - sep.19.2008	register
Washington, DC	jul.14.2008 - jul.18.2008	register
Miami, FL	may.12.2008 - may.16.2008	register
Chicago, IL	jun.23.2008 - jun.27.2008	register
Bellevue/Seattle, WA	jun.16.2008 - jun.20.2008	register
Bellevue/Seattle, WA	sep.15.2008 - sep.19.2008	register

who can benefit

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

prerequisites

You should complete:

? DB2 Family Fundamentals (CF030)
? DB2 SQL Workshop (CF120)
? OR have equivalent experience

You should be able to:

? Design a relational table
? Describe the SQL data manipulation statements to access and change the contents of DB2 tables

skills gained

	Define and maintain the objects that make up a DB2 database
	Resolve referential and check constraint violations
	Load external sequential input data into DB2 tables
	Gather statistics about DB2 data
	Reorganize DB2 data
	Unload DB2 data in external format
	Recover a damaged table space to current
	Compress data
	Bind a DB2 application program
	Control access to DB2 objects
	Describe basic DB2 serialization concepts

course materials

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

hands-on labs

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

certification

Prepare for IBM Certification Test 702, DB2 UDB V8.1 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

	before related training and products

	CE030 DB2 Family Fundamentals
	CE120 SQL Workshop

	after related training and products

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

course content details

	Introduction

	understand the fundamental difference between static and dynamic SQL programs
	define the major responsibility of any application program
	define the major responsibilities of the DB2 system
	understand the basic principles of DB2 recovery
	discuss the basic roles people play in a DB2 shop

	Setting up a DB2 database

	describe the DB2 objects that make up a DB2 database
	select the most appropriate parameters for these DB2 database objects so that they are implemented with the most appropriate attributes
	create storage groups, databases, table spaces, tables, views, synonyms, aliases, materialized query tables and indexes
	alter the attributes of DB2 database objects as requirements change over time
	describe how data is stored in a DB2 database

	Referential Integrity (RI)

	describe the concepts of PRIMARY KEY, UNIQUE KEY and FOREIGN KEY
	implement these keys in DB2
	describe the concepts of REFERENTIAL CONSTRAINT and RI
	implement REFERENTIAL CONSTRAINTS on new or existing tables with the appropriate DELETE rules
	drop REFERENTIAL CONSTRAINTS and their enforcing indexes
	query the appropriate catalog tables for RI details
	discuss identity columns and sequence objects

	Getting data into and out of DB2

	describe the importance of free space and implement an appropriate quantity in DB2 table spaces and index spaces
	describe how free space is used by DB2 during SQL INSERT, DELETE, and UPDATE processing and how free space is managed by DB2 during LOAD, REORG, RECOVER INDEX and REBUILD INDEX
	describe how DB2 utilities may be executed, monitored, terminated and restarted.
	run the DB2 LOAD utility and make full use of its many features
	run the CHECK DATA utility to check DB2 table space data for any violations of referential integrity constraints or table check constraints
	run the DB2 UNLOAD utility and make full use of its many features in a DB2 UDB for z/OS and OS/390 Version 7 system or later

	Keeping your DB2 data in good shape

	describe and interpret the statistics collected by RUNSTATS
	run RUNSTATS with an appropriately chosen set of options
	describe why it is necessary to periodically REORG your table spaces and indexes
	run REORG with an appropriately chosen set of options

	Application Data Recovery Basics

make DB2 user data available again following media failures

	ESA data compression

	describe the data compression feature
	specify it for a table space
	use the DSN1COMP utility to determine if its specification will help conserve Direct Access Storage Device (DASD) space

	Program Preparation / Bind

describe the main steps needed to prepare a program that accesses DB2 with embedded static SQL

	Security

	describe DB2 global security
	describe the various DB2 authids and how they are established
	understand how DB2 security controls access to data
	describe and implement DB2 privileges and authorities appropriately
	describe how ownership is established in DB2
	describe DB2 authorization checking
	describe and implement security for plans and packages
	describe multilevel security
	describe the advantages and considerations for using the Resource Access Control Facility (RACF) / DB2 external security module

	Serialization

	describe concurrency
	explain the aspects of transaction locks
	tell when locks are acquired and released
	describe S-Locks and X-Locks
	Explain isolation levels
	Explain LOCKSIZE

	The course also includes extensive machine lab exercises which give you the opportunity to gain hands-on experience of:

creating and using databases, table spaces, tables, views and indexes defining check and referential constraints creating and running the following utility jobs: LOAD, CHECK DATA, and UNLOAD; RUNSTATS and REORG; COPY and RECOVER DB2 security DB2 locking