On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

DB5010 DB2 for z/OS System Administration & Performance Basics
 
 
Duration 4 Days
Delivery Method Instructor Led, Lecture
Public Price $2250.00


DESCRIPTION (Return to Top)

This 4-day course is a must for all personnel who need a comprehensive understanding of the DB2 System environment. During this hands-on course the attendee will install their own DB2 subsystem, migrate their subsystem to a new release and analyze each address space for workload and performance considerations. Additionally detailed attention is given to the layout and content of the various DB2 data & system structures, what facilities are supplied to manage the DB2 environment and how DB2 relates to the z/OS environment. This course also reviews the DB2 Install parameters and presents an introductory approach to tuning your system.



AUDIENCE (Return to Top)

DB2 Systems Programmers, DB2 Systems Administrators and Technical Database Administrators.



OBJECTIVES (Return to Top)

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


TOPICS (Return to Top)
  • Introduction to the DB2 Environment
  • DB2 Installation
  • DB2 Migration
  • 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


PREREQUISITES (Return to Top)

An overview understanding of DB2, basic understanding of z/OS.