Каталог курсов

Курсы IBM

Администрирование DB2 V10 (Linux, UNIX, Windows)

 
Код курса  Код: CL2X3UA    Заявка  Предварительная запись    Продолжительность  Кол-во часов: 40 , Кол-во дней: 5


IBM.gif

Подробное описание курса.

Description


This course teaches you to perform basic database administrative tasks using DB2 10.1 for Linux, UNIX, and
Windows. These tasks include creating and populating databases and implementing a logical design to
support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using
the DB2 Explain tools. Various diagnostic methods will be presented including using the db2diag.log file
messages to direct your investigation of problems as well as using the db2pd commands

Objectives


  • Administer a DB2 database system using commands and GUI tools
  • Compare DMS, SMS, and Automatic storage management for table space storage
  • Implement a given logical database design using DB2 to support integrity and concurrency requirements
  • List and describe the components of DB2
  • Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
  • Use autonomic features of DB2
  • Examine Explain output to determine access strategy chosen by Optimizer
  • Investigate current application activity that might indicate performance problems using SQL statements
  • Implement DB2 security

Audience

This intermediate course is for system administrators, database administrators, and technical personnel
involved in planning, implementing, and maintaining DB2 databases.

PreRequisites

You should be able to:

  • Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
  • State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and
authorization statements
  • Discuss basic relational database concepts and objects such as tables, indexes, views, and join
  • These skills can be developed by taking:
  • OS Training:
  • AIX 5L Basics
  • Linux Basics and Administration
  • Windows Systems Administration
  • Or by having equivalent HP-UX or Solaris administration experience
  • DB2 SQL Workshop
  • DB2 Fundamentals

Topics


1. Overview of DB2 on Linux, UNIX and Windows
2. Command Line Processor (CLP) and GUI usage
3. The DB2 environment
4. Creating databases and data placement
5. Creating database objects
6. Moving data
7. Backup and recovery
8. Database Maintenance, Monitoring, and Problem Determination
9. Locking and concurrency
10. Security
11. Agenda

12. Day 1

  • Unit 1: Overview of DB2 on Linux, UNIX and Windows
  • Unit 2: Command Line Processor (CLP) and GUI usage
  • Unit 3: The DB2 Database Manager Instance
  • Exercise 1: Create a New DB2 Instance
  • Unit 4: Creating databases and data placement
  • Exercise 2: Creating databases and data placement

13. Day 2

  • Unit 5: Creating database objects
  • Exercise 3: Create objects
  • Unit 6: Moving data
  • Exercise 4: Moving data

14. Day 3

  • Unit 7: Backup and recovery
  • Exercise 5: Backup and recovery
  • Unit 8: Database Maintenance, Monitoring, and Problem Determination
  • Exercise 6: Using DB2 Tools for Performance

15. Day 4

  • Unit 7: Locking and concurrency
  • Exercise 7: Investigating DB2 Locking
  • Unit 8: Security
  • Exercise 8: Database Security

Related


You may also be interested in the following courses
This course enables you to acquire the skills necessary to produce application programs that manipulate
DB2 databases. Emphasis is on ...

DB2 Programming Workshop for Linux, UNIX and Windows CL100UA
Get the technical information about the new functions and features available in DB2 9.7 for Linux, UNIX,
and Windows for ...

DB2 9.7 for Linux, UNIX, and Windows New Features CL312UA

 

 

Дополнительную информацию по учебным программам IBM в Украине вы можете получить на сайте: www.ibm.com/training/ua (Учебный центр в Украине).


Ссылка курса обучения
Назад в раздел





Для предварительной записи на курсы или
уточнения информации позвоните по телефонам:
(044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua

Или заполните заявку online.