Understanding & Using DB2 UDB for Linux/UNIX/Windows

Objectives
On successful completion of this course, attendees will be able to:

• use Command Center, Control Center, or other SQL execution environment (e.g. WinSQL) to code SQL statements
• use the System Catlaog
• understand and control the locking strategy used by DB2 to maintain data integrity
• describe the different development environments available
• explain the use and implementation of the Development Center
• ist the different types of indexes and the use of Index Advisor
• use Visual Explain
• use and understand the Health Center to describe the development and execution of Utilities
• explain the use of Journals
• describe the Replication Center
• explain the use of the Task Center
• use the Event Analyzer
• describe the Indoubt Transaction Manager
• use the Memory Visualizer
• describe the Configuration Assistant.

Who Should Attend
IT personnel who are exposed to, or required to write and perform activities associated with application development and implementation in a DB2 UDB Linux, UNIX, and/or Windows environment.
Prerequisites
Those attending the course should be familiar with DB2 in a mainframe environment.
Duration
2 days

Course Code
DBWC
Contents
Introduction to DB2 under Linux/UNIX/Windows
Versions; system architecture.


Terms/terminology
Database, Buffer Pool, Instance, Tablespace; Tables; Views; View Merge; Materialization; Columns; Nulls; Referential Integrity; Alias; Attributes.


DDL via CONNECT commands or the Control Center



The Locking strategy
Principles and implementation.


Indexing
The different types of index available, Index Advisor, creation, Visual Explain, and Muti Dimentional Clustering.


Stored procedures and UDFs
Development using the Development Center; SPL; execution.


DB2 Utilities
REORG, RUNSTATS, BACKUP, RESTORE, LOAD,IMPORT and EXPORT.


Other options
Journals, Replication Center, Task Center, Event Analyzer, Health Center, Indoubt Transaction Manager, Memory Visualizer, and Configuaration Assistant.