This 4-day course is intended for Systems Programmers, Systems Administrators and Technical Database Administrators. The course describes the layout and content of the various DB2 data and system structures, what facilities are supplied to manage the DB2 environment and how DB2 relates to the MVS environment. This course also reviews the DB2 Install parameters and presents an introductory approach to tuning your system. A must for all personnel who need a comprehensive understanding of the DB2 System environment.

New DB2 System Programmers, System Administrators and/or experienced Technical Database Administrators.

Attendees will gain a working knowledge of:

• DB2’s Multi-Address space Subsystem
• DB2’s System Resources
• DB2 Installation Tailoring
• What factors affect DB2 Subsystem performance

• Introduction
• DB2 Subsystem Structure
• DB2 Database Services Address Space
• DB2 System Services Address Space
• DB2 Internal Resource Lock Manager and Concurrency Control
• DB2 Distributed Data Services
• DB2 Stored Procedures
• DB2 Data Sharing Overview
• DB2 Security

An overview understanding of DB2, basic understanding of MVS.