DB2 for LUW: Introduction & Fundamentals


This course introduces and explains the fundamental principles of the DB2 for Linux, UNIX and Windows family of products. The course focuses on the relational theory and concepts, and how DB2 adheres to them. It also introduces the basic concepts of DB2 data storage, SQL, DB2 utilities, and the use of DB2 Interactive (DB2I) and the relevant centres.

This course is available for one-company, on-site presentations.

Objectives

On successful completion of this course you will be able to:

  • describe the relational theory and concepts
  • list the objects used to store DB2 data
  • understand the use of Structured Query Language
  • describe the functions available with DB2 Interactive (DB2I)
  • list the utility jobs available for DB2.

Who Should Attend

All IT professionals who need to understand the full range of the DB2 for LUW family of products.

Prerequisites

A basic understanding of IT, with some exposure to database technology as a user.

Duration

2 days

Fee (per attendee)

P.O.A.

Course Code

DBFF

Contents

DBMS Overview

A database is...; DB2 is...; Hierarchical database structure; Network database structure; Relational database structure; Table structure; DB2 family & versions.

Relational Theory & Concepts

E F Codd; The relational model; Structure: tables, rules for columns and rows, keys, Primary and Foreign keys; Manipulation: relational algebra, project, Restrict, join, UNION; Domain and user-defined Integrity; Entity and Referential Integrity; Referential Integrity: INSERT, UPDATE, DELETE.

DB2 Data & System Overview

DB2 objects; the DB2 database; Tablespace and Instance; Tablespace formats; Table; SYNONYM & ALIAS; View; Index; Index structure; Storage group; User defined datasets; Schema; Trigger; DB2 catalog & directory; DB2 address spaces; DB2 attachments; Buffer Pools & Hiperpools; DB2 logging.

Structured Query Language Overview

Structured Query Language; Data Definition Language commands & examples; Data Control Language commands & examples; Data Manipulation Language commands; SELECT; INSERT; UPDATE; DELETE; COMMIT / ROLLBACK; DB2 Optimizer.

DB2 Interactive (DB2I) and Command Center Overview

DB2I primary option menu; Panels: SPUFI defaults; Precompile; Option 5 - BIND / REBIND / FREE; Option 6 - RUN; Option 7 - DB2 commands; Option 8 - DB2 Utilities; Invoking DB2 Utilities.

DB2 Utilities Overview

Controlling Utilities; Backup & Recovery Utilities; Integrity & consistency utilities; General utilities; Stand-alone utilities.

The Centers

Development Center; Replication Center: Introduction, Create the capture control tables, Register a source table, Create the apply control tables; Task Center: Introduction, Creating a task; Event Analyzer; Health Center: How it works, Type of alert/action/indicators, Using, Configure, Recommendation Adviser; Indoubt Transaction Manager; Memory Visualizer; Configuration Assistant.


© RSM Technology 2017