DB2 for LUW: Linux/UNIX/Windows Introduction


This course introduces and explains all aspects of relational technology as implemented by DB2 for Linux, UNIX and/or MS Windows. The course is designed for applications programmers, designers, analysts and DBAs who have used DB2 in a mainframe environment. The presentation combines formal tuition with practical workshop sessions.

Objectives

On successful completion of this course you 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
  • list 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 for Linux, UNIX, and/or Windows environment.

Prerequisites

Those attending the course should be familiar with computing environments.

Duration

2 days

Fee (per attendee)

P.O.A.

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.


© RSM Technology 2017