Administering Data Placement in DB2 UDB

Overview/Description
To describe the administration and placement of data in a DB2 UDB database

Target Audience
Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator

Prerequisites
A good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL

Expected Duration
160 Minutes

Objectives:

Administering Data Placement in DB2 UDB

  • create databases using the CREATE DATABASE command and the Create Database Wizard.
  • demonstrate an awareness of the database creation process.
  • create a database and explain aspects of the database creation process.
  • distinguish between SMS and DMS tablespaces and the data they hold.
  • create and modify tablespaces and obtain information about a database.
  • manage tablespaces in DB2 UDB.
  • create and modify buffer pools in a DB2 database.
  • create DB2 UDB tables.
  • generate the SQL to create a new buffer pool and a new table.


    • Course Number: 217409_eng