Font size:

Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem with hands-on labs to gain experience.

Note: While class exercises are performed within a DB2 11 for z/OS environment, our expert instructors can provide guidance on all versions and their differences.�



Highlights:
  • Relate the z/OS IPL process to a DB2 subsystem
  • Effects of stopping and starting DB2
  • How DB2 sets and use Integrated Catalog Facility (ICF) catalog names
  • Use of DSN command processor running in batch and�foreground
  • Use views to minimize users' ability to see into the DB2�catalog
  • See how the catalog (through grant activity) controls access�to data
  • Search the catalog for problem situations
  • Use the catalog and DB2 utilities to determine data recovery�requirements
  • Internal Resource Lock Manager (IRLM) in a DB2�environment
  • Implement DB2 and Resource Access Control Facility (RACF) security
  • DB2 program flow for all environments
  • Display normal and problem threads and database status
  • How the SQL Processor Using File Input (SPUFI)�AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
  • Interpret lock displays
  • Identify and cancel particular threads
  • Available DB2 utilities to manage system and user�page sets

Prerequisites:
  • An understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered
  • A working knowledge of SQL�
  • At least one year as a z/OS systems programmer or equivalent experience
  • Or, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience


Audience:

This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS.

Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live2/12/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days3595.002456258
Virtual Live3/5/2018 11:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days3595.002456255
Virtual Live4/16/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days3595.002456259
Virtual Live6/18/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days3595.002456261
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 4 of 4 items