Know Db2

Db2 12 for z/OS - System Architecture

This class and workshop examines the structure of a Db2 subsystem and its components. Understanding the environment that makes up a Db2 subsystem is the base line for working with Db2 12 for z/OS.

Duration: 2 Day Hands - on Labs/Remote Access.

Audience: Anyone who will be working with Db2 12 for z/OS including database administrators, system administrators and new Db2 z/OS team members.

Prerequisites: Working knowledge of Db2 on z/OS, TSO, JCL, and SPUFI or experience with other Relational Database products.

Db2 12 for z/OS - System Architecture

Class Outline:

Db2 in the z/OS Environment

  • -Introduction to Db2 12 for z/OS
  • -Overview of hardware and software
  •  

Inside Db2 Address Spaces and Structures

  • System Services
  • -BSDS
  • -Logs - Active / Archive
  • -Threads
  • Database Services
  • -Buffer Pools
  • -EDM Pools
  • -Catalog/Directory Overview
  • -Workfiles
  • -Sort Space
  • IRLM
  • -Support of Locking
  • Distributed Data Facility
  • -Remote Systems
  • Work Load Manager
  • -Stored procedures and user-defined functions
  • -External Stored Procedures
  • -Native Stored Procedures
  • Allied Address Spaces
  • -TSO, CICS, IMS, Batch
  • Locating the currently running zParms
  • -Basics if macros in zParms
  • -How to start/stop Db2
  • -Assembly of zParms
  • -SDSF Commands
  • -Structure of SDSF
  • Messages and Codes
  • Db2 Data Sharing Overview
  • -Parallel Sysplex
  • -Data Sharing Group
  • Attachment Facilities
  • -CAF and Allied Agents
  • Db2 GRANT/REVOKE and RACT
  • -Security of your data
  •  

Db2 Directory and Catalog Detail

  • SYSIBM.SYS naming convention
  • Directory Tables and their use
  • Catalog Data Structure Management
  • Db2 Catalog Details
  • Look at the data structures and management
  • Tables and uses
  • Developing Useful Catalog SQL
  • Review and Labs
  •  

Utility and Commands

  • Db2 Commands
  • Review of most used commands
  • DSNU Utility
  • LOAD, UNLOAD
  • QUIESCE
  • REORG
  • REBUILD
  • RUNSTATS
  • DISPLAY UTILITY output
  • Review and Labs
  •  

Stand Alone Utilities in Db2 Review

  • DSNJCNVB
  • DSNJLOGF
  • DSNJU003, DSNJU004
  • DSN1CHKR
  • DSN1COMP
  • DSN1COPY
  • DSN1LOGP
  • DSN1PRINT
  • DSN1SDMP
  • Review and Labs
  •  

Db2 12 Data Definition Language

  • CREATE DATABASE
  • CREATE TABLESPACE, TABLE
  • CREATE INDEX
  • ALTER and DROP
  • EXPLAIN overview
  • Review and Labs
  •  

Class Summary and Review

  • © Computer Business International, Inc.

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