DB2 UDB Family - Introduction & Fundamentals

Objectives
On successful completion of this course, attendees 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 DB2 UDB family of products.

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

Duration
2 days

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.