View Printable Version

EDS1 - DB2 11 for z/OS System Administrator Crammer Class for Certification Exam #317

Session Number: 2536
Track: Ed. Sem
Session Type: Educational Seminar
Primary Presenter: Judy Nall [System Adminstrator - Computer Business International, Inc. (Cbi)]

Adams => Mon, May 04, 2015 (10:15 AM - 06:00 PM)

Speaker Bio: Judy H. Nall is an internationally recognized DB2 for z/OS lecturer, consultant, writer and educator for Computer Business International, Inc. (CBI). Judy supports CBI customers by providing consulting services and classes on DB2 for z/OS.
She is an IBM Gold Consultant, IBM Data Champion, member of the IDUG RUG Committee, president of the Alabama DB2 Users Group, works
with IBM to develop the DB2 for z/OS IBM Certification Exams, has IBM certifications in DBA and System Administrator for DB2 9,10,11, and is the Author of : DB2 9 System Administration for z/OS: Certification Guide
She can be reached at

Audience experience level: Intermediate
Presentation Category: Data Management
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Database Administrators, Systems Programmers
Technical areas this presentation will apply to: New Release (DB2 for z/OS)
Objective 1: Understanding the objectives of the #317 Exam for DB2 11 for z/OS System Administrator.
Objective 2: Discovering the changes to DB2 11 for z/OS that relate to the testing.
Objective 3: Understanding how those changes are implemented as they relate to planning, installing, managing, tuning, maintenance and securing DB2 11 for z/OS.
Objective 4: Reviewing practice certification questions at the end of each chapter to prepare students for the exam.

Abstract:  Chapter 1 - Installation and Migration Topics for DB2 11 for z/OS
--- Architecture, storage, migration differences, overview of applying maintenance with SMPE, installation enhancements. Review Questions.

Chapter 2 - Security & Auditing Topics
--- Protecting resources, new system authorities, role based, audit tracing, distributed identities.

Chapter 3 - System Operation & Maintenance
--- New REORG options, Utilities/changes, MVS Commands, Monitor/control threads.

Chapter 4 - Backup and Recovery Topics
--- System requirements, backup/recovery procedures, commands, REPORT/MODIFY, BACKUP/RESTORE system, disaster recovery processes, and scenarios.

Chapter 5 - Performance & Tuning Topics
--- Analyzing performance in DB2, tracing, buffer pool performance, thresholds/ratios, sort pool, work files, RID pool, use of memory, tuning with zParms, workload manager settings, and autonomic/manual RUNSTATS.

Chapter 6 - Trouble Shooting Topics in DB2 11 for z/OS
--- Tuning elements, components/processes, tools for problem resolution, stand alone/diagnostic utilities, space issues, log issues, WLM/Stored Procedures.

Each Chapter has review questions for practice.

For questions or concerns about your event registration, please contact