Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Data Placement and Access

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

Audience

Database administrators responsible for DB2 databases and data storage

Prerequisites

A basic understanding of DB2 and DB2 fundamentals

Course Aim

To explain how to manage and control database storage and access

Learning Objectives

Create a database. Understand the use of schemas in data placement. Understand storage concepts. Differentiate between DMS and SMS table spaces. Manage table spaces. Bind applications to databases. Create indexes, constraints, and views on tables. Collect and use statistics.

Topics Covered

Data placement - Database creation - Schemas - Containers - Extents Table spaces - Creating table spaces - The SMS table space - The DMS table space - Table space management Database access - Binding applications - Using indexes - Using constraints - Using views DB2 statistics - Use of statistics - Using RUNSTATS - Analyzing statistics