Know Db2

Db2 11 for z/OS System Administrator Crammer Class for Certification Exam #317

This one-day crammer class reviews the six certification testing topics relating to the: IBM Certified System Administrator – Db2 11 for z/OS Certification Exam C2090-317.

Students will be guided by class room lecture through:

PREREQUISITES: Students attending this class should have experience in at least one of the following: Database Administration, System Administration, or a Lead Architect/Programmer in Db2 Version 8, 9 or 10 for z/OS. This is an intermediate to advanced Db2 11 for z/OS class.

AUDIENCE DESCRIPTION : 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.

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:

Installation and Migration Topics in Db2 11 for z/OS

  • System Structure – Discussion of the Architecture
  • -Db2 components and Resource Managers
  • -Address Spaces, Work requests in DB2
  • -Attachment Facilities
  • -Storage-Real and Auxiliary
  • -Shared Virtual Memory
  • Migration and Install differences – What I need to know
  • -Db2 11 Products and Features
  • -Release incompatibilities
  • -Preplanning & Prerequisites
  • -Db2 10 to Db2 11 migration
  • -Installation/Migration process
  • -Identifying additional service environments
  • -Catalog and Directory changes
  • -DBM1 Storage changes
  • -DSNZPARM planning
  • Methods and Applying Maintenance in Db2
  • Rudimentary knowledge of SMP/E
  • Overview of the steps in applying maintenance in DB2
  • Enhancements to the Installation/Migration Process in DB2 11
  • Review & Practice Questions

Security and Auditing Topics in Db2 11 for z/OS

  • Protecting Db2 subsystem and resources
  • New system authorities
  • Support for Distributed identities
  • Connection Level security enforcement
  • Audit Tracing/Policies
  • Role-Based Security
  • Review & Practice Questions

System Operation and Maintenance Topics in Db2 11 for z/OS

  • New reorg catalog options
  • Key Db2 Commands
  • -Uses, Authorization, Output
  • Db2 11 Utilities Changes to Know
  • MVS Commands to Know
  • Monitor and control Db2 threads
  • Review & Practice Questions

Backup and Recovery Topics in Db2 11 for z/OS

  • System Requirements
  • System level backup and recovery procedures
  • REPORT and MODIFY Utility
  • Commands
  • Db2 Disaster Recovery process
  • Db2 Data Sharing Recovery
  • Scenarios
  • Review & Practice Questions

Performance and Tuning Topics in Db2 11 for z/OS

  • Analyzing performance
  • Tracing in Db2
  • Buffer Pools and performance
  • -Thresholds/Ratios
  • -Page Management
  • -Statistics
  • Sort Pool, Work Files
  • EDM Pool, RID Pool
  • Efficient use of memory
  • DSNZPARMs and tuning
  • Workload manager settings for Db2
  • Autonomic vs. manual RUNSTATS
  • Review & Practice Questions

Troubleshooting Topics in Db2 11 for z/OS

  • Tuning Elements
  • Components and Processes
  • Problem Resolution Methods
  • Tools for Problem Resolution
  • Stand-alone and Diagnostic Utilities
  • Space Issues and Log Issues
  • WLM and Stored Procedures
  • Review & Practice Questions
  • Class Summary
  • ©2017 Computer Business International, Inc.



Would you like to schedule this class?
Please call our toll free number (866-224-4968) or email us at