| |
|
| |
Administering Data Placement in DB2 UDB Training Class |
|
| |
|
|
| |
|
|
| |
Administering Data Placement in DB2 UDB Training Seminar
To describe the administration and placement of data in a DB2 UDB database
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
US$ 74.95
|
|
| |
|
|
| |
Agenda |
|
| |
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.
|
|
|
| |
|
|
| |
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
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
A good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|