Administering Data Placement in DB2 UDB

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

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

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

WEB

Creating DB2 databases using wizard and command options| - create databases using the CREATE DATABASE command and the Create Database Wizard.|The DB2 database creation process| - demonstrate an awareness of the database creation process.|Implementing the DB2 database creation process| - create a database and explain aspects of the database creation process.|Tablespaces in DB2 UDB databases| - distinguish between SMS and DMS tablespaces and the data they hold.|Working with SMS and DMS tablespaces in DB2| - create and modify tablespaces and obtain information about a database.|Managing DB2 tablespaces| - manage tablespaces in DB2 UDB.|Buffer pools in DB2 UDB| - create and modify buffer pools in a DB2 database.|Tables in DB2 UDB| - create DB2 UDB tables.|Creating DB2 database objects| - generate the SQL to create a new buffer pool and a new table.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...