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 Days - Hands-on Labs/Remote Access
Audience: Anyone who will be working with Db2 12 for z/OS including database administrators, system sdministrators 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.
For scheduling information please call our toll free number at 1.866.224.4968 or visit our website at cbi4you.com
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
- • Data Facility
- -Remote Systems
- • 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
- • Useful Catalog SQL
- • Review and Labs
Utility and Commands
Commands & Utilities Overview
- • Db2 Commands
- • Review of most used commands
- • DSNU Utility
- • LOAD, UNLOAD
- • QUIESCE
- • REORG
- • REBUILD
- • RUNSTATS
- • DISPLAY UTILITY output
- • Review and Labs
Stand Alone Utility in Db2 Review
Utilities Outline
- • 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
- To Schedule this class call 1.866.224.4968
- © 2019 Computer Business International, Inc.