Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Database Objects and Concurrency

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Database administrators and application developers involved in managing databases or creating applications in DB2 databases

Prerequisites

A basic understanding of relational databases and SQL; the ability to create and configure a DB2 database; completion of the course IBM DB2 Universal Database 5.0: Database Creation, Access, and Manipulation

Course Aim

To discuss DB2 database objects and concurrency mechanisms

Learning Objectives

Identify the data types supported by DB2. Identify database objects and their uses. Understand the use of table spaces, extents, and buffer pools in data management. Explain database concurrency. Understand isolation levels. Describe the locking mechanisms implemented by DB2 to ensure data concurrency.

Topics Covered

Database objects - Data types - Tables - Views - Indexes - Packages Data placement - Table spaces - Extents - Buffer pools Database concurrency - Concurrency - Isolation levels - DB2 locks