Know Db2

Db2 12 for z/OS System Administrator Crammer Class for Certification

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

Duration:
1 Day - Lecture and Question Reviews

PREREQUISITES: Working knowledge of previous Db2 versions on z/OS, TSO, JCL, and SPUFI.

Class Outline:

Db2 12 for z/OS Installation and Migration
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 12 Products and Features
  • Release incompatibilities
  • Preplanning & Prerequisites
  • Db2 11 to Db2 12 migration
  • Installation/Migration process
  • Identifying additional service environments
  • Catalog and Directory changes
  • DBM1 Storage changes
  • DSNZPRAM 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 12
  • Review and Practice Questions
  •  

Security and Auditing Topics in Db2 12 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 12 for z/OS

  • New reorg catalog options
  • Key Db2 Commands
  • Uses, Authorization, Output
  • Db2 12 Utilities Changes to Know
  •  

System Operaton and Maintenance Topics in Db2 12 for z/OS - (Cont.)

  • MVS Commands to Know
  • Monitor and Control Db2 Threads
  • Review and Practice Questions
  •  

Backup and Recovery Topics in Db2 12 for z/OS

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

Performance and Tuning Topics in Db2 12 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 12 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
  •  
  •  
  •  
  •  
  • ©2019 Computer Business International, Inc.

 

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