SUMMARY:   Suitable for the BCS Mainframe Technology professional Exams for level 2 Engineer (Operations Analysis) AUDIENCE:   All personnel who will be working with DB2 and require a comprehensive overview of the functions of DB2, the DB2 product family (up to DB2 9) and how to utilise the DB2 environment under all platforms (Linux, UNIX, Windows, iSeries and z/OS). PREREQUISITES:   There are no required prerequisites, but a basic understanding of relational databases is useful. DURATION:   1 day. Hands on. OBJECTIVES:   This course is a basic introduction to DB2, IBM's Relational Database Management System. It will present to the student a comprehensive overview of the DB2 Product. DB2 as a formal DBMS (Data Base Management System) is presented in a manner that will enhance the attendees utilisation and implementation of DB2. The course includes an introduction to DB2 and how it performs as both a formal DBMS and a Relational DBMS; as well as presenting the facilities that are included in the DB2 product. After taking this course the student should be able to understand: - The objects that comprise a Relational Database. - The components that make up the DB2 Product. - The tabular format of data, and how these tables are related. - The DB2 Environment and its associated attachments. - The functions of the Structured Query Language (SQL) - Execution Environments. COURSE CONTENT:   Introduction to Relational Database Systems Definition of a Relational Data Base Management System The relational model and how it is implemented by the DB2 product The relational rules that govern RDBMS's and how well DB2 supports those rules The DB2 Structure Logical Data Structures Physical Data Structures The System Objects Catalog Communications Database Logging Locking Buffer Pools The DB2 Environment The DB2 Operational Environment Distributed Data Facility Data Sharing Structured Query Language Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Dynamic SQL Static SQL Embedded SQL Application Development using SQL The DB2 Facilities and Product Family DB2 Interactive (DB2I) / Command Center / Control Center / Command Prompt SPUFI (SQL Processing Using File Input) DB2 Utilities DB2 Implementation and Use DB2 support structure DB2 policies and procedures DB2 standards DB2 Implementation task list IC06/01