EDS3 - DB2 11 for z/OS System Administration Certification Crammer Course

Session Number: 4290
Track: EDSEM
Session Type: Educational Seminar
Primary Presenter: Judy Nall [Computer Business International, Inc. (CBI)]
Time: Apr 30, 2017 (09:00 AM - 05:00 PM)
Room: North Exhibit Hall Room E

Speaker Bio: Judy H. Nall works with Computer Business International, Inc. (CBI) and is an internationally recognized DB2 lecturer, consultant, writer and educator. Judy is a member of the IBM DB2 Gold Consultants Group, an IBM Data Champion and a member of the NA IDUG Regional User Group committee. She has worked with DB2 for z/OS since the first release. She is the author of two DB2 for z/OS books. Her latest book is, DB2 11 System Administration for z/OS: Certification Study Guide.
Audience experience level: Intermediate, Advanced
Presentation Category: Data Management, Implementing New DB2 Releases and Features, Managing Database Resources
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), Disaster Recovery (DB2 for z/OS), New Release (DB2 for z/OS)
Objective 1: A one-day crammer course which will cover topics in the six sections of the - IBM Certified System Administrator – DB2 11 for z/OS Certification Exam C2090-317.
The exam topics reviewed in the class:
1 )Installation and Migration Topics
Objective 2: 3) System Operation and Maintenance Topics in DB2 11 for z/OS
a. New reorg catalog options
b. Key DB2 Commands
i. Uses, Authorization, Output
c. DB2 11 Utilities Changes to Know
d. MVS Commands to Know
Review & Practice
Objective 3: 4) Backup and Recovery Topics in DB2 11 for z/OS
a. System Requirements
b. System level backup and recovery procedures
c. REPORT and MODIFY Utility
d. Commands
f. DB2 Disaster Recovery process
Objective 4: 5) Performance and Tuning Topics in DB2 11 for z/OS
a. Analyzing performance
b. Tracing in DB2
c. Buffer Pools and performance
i. Thresholds/Ratios
ii. Page Management
iii. Statistics
d. Sort Pool, Work Files
e. EDM
Objective 5: 6) Troubleshooting Topics in DB2 11 for z/OS
a. Tuning Elements
b. Components and Processes
c. Problem Resolution Methods
d. Tools for Problem Resolution
e. Stand-alone and Diagnostic Utilities
f. Space Issues and Log Issues&

Abstract:  This one-day review crammer course guides students through the six testing sections that comprise the #317 Exam. Review questions and answers accompany each section of the lecture material. Students attending this crammer course will review tasks, methods and responsibilities of a DB2 11 for z/OS System Administrator as they relate to the #317 testing areas.