DB2 for z/OS fundamentals course (EN/NL/FR)

This 3 day ABIS course presents a detailed description of the Db2 system on z/OS: what it is, what it is intended for, and how it can be used. In addition, the course teaches how the system is used in practice. At the end of the course the participants will not only have the necessary theoretical knowledge of Db2 as an RDBMS, they will also have had sufficient practical training to start working with Db2 in an independent way. Intended for anybody wanting to gain a thorough knowledge of DB2; participants must have insight in an RDBMS and must be able to write SQL statements.

Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in Dutch, English, and French. Consult the ABIS website for alternate course formats.

Main topics:

• Introduction: Db2 environment; client-server model
• Relational system: position within the relational model
• SQL data definition language (DDL): the Db2 objects (tables, tablespaces, indexes, views, ...): characteristics, creation, use, and parameters
• SQL embedded in a program: development cycle, pre-compilation, compilation, BIND, plans and packages
• The Db2 catalog
• Security and authorization
• Utilities: LOAD, UNLOAD, CHECK DATA, RUNSTATS, REORG
• Integrity, locking
• Performance: basic principles, the EXPLAIN function

Intended for/Audience: Analysts, programmers, and database administrators who will be using Db2; and anybody wanting to gain a thorough knowledge of a relational database system. 

Background/Prerequisites: The participants must have insight in relational database systems and they must be able to write SQL select statements.  Some knowledge of ISPF/PDF and of COBOL, PL/I, or SQL PL is advisable.

Training Method/Didactics: Classroom instruction with exercises (about 50% of the time).

Duration: 3 days.