BMC Mainframe: Db2 for z/OS - Systems Administration

Architecture overview
Working Storage Areas
Buffer, Sort, RID & EDM pools
Buffer Pools - 64 bit addressing
EDM pool
Sort pool
RID pool
Db2 Attachments
System data sets & databases
Db2 objects
Object characteristics
SQL overview
DB2 Interactive (DB2I)
Basic Db2 operations
Db2 commands
DB2I commands panel.
This segment examines the major components of the Db2 system

DASD storage requirements
Storage estimates (Db2 system)
Storage estimates (Db2 datasets)
DASD requirements - user data
DASD requirements - user indexes
Virtual storage requirements

Buffer, Sort & RID pool storage
EDM pool storage
DSCBs and working storage
Real storage estimation
Planning for data sharing.
This segment identifies the major tasks involved in planning for the installation and/or migration of a Db2 subsystem

Definitions
Db2 modes (Db2 11)
Db2 Function Levels (Db2 12)
Installation / Migration step
The major Installation / Migration tasks
Additional tasks and jobs
Loading Db2 libraries (the SMP/E process)
The installation CLIST
Invoking the installation CLIST
Updating the CLIST defaults (DSNTIJXZ)

DSNTIPA1 - Installation CLIST Main Panel
DSNTIP0A - data sharing options (Type INSTALL)
DSNTIP0B - data sharing options (Type MIGRATE)
Installation CLIST Panels (Db2 12 for z/OS)
Optional Installation Panels
DSNTIPC, DSNTIPC1 - CLIST calculations
The customised jobs
Jobs DSNTIJUx - Define parameters.
This segment describesand explains the major tasks involved in the installation and/or migration of a Db2 subsystem

Migration considerations
Pre-migration queries (DSNTIJPM)
Migration compatibility
Migration tasks
Prerequisites & maintenance level of current system
Integrity of current system
Back-up current system
Migration steps
Other migration tasks

Fallback
Enabling New Function Mode (ENFM) jobs
Activate (change Function Level) jobs
Updating Db2 - using the installation CLIST
Updating Db2 - modifying the generated job(s)
Invoking modified parameters
-SET SYSPARM command
This segment describe and explains the tasks involved in migration and modification of a Db2 subsystem

Db2 Attachments
Db2 connections (Attachments)
Universal Language Interface Module (DSNULI)
DSNULI entry points
TSO Attachment
Job DSNTIJVC - Build the CLIST library
Make libraries available to TSO
Connect DB2I panels to main panel
Invoking TSO Attachment
CICS Attachment
CICS / Db2 connection
Defining Db2CONN
Defining Db2ENTRY
Defining Db2TRAN
Controlling CICS Attachment

IMS Attachment
IMS Subsystem Member (SSM)
Subsystem Member relationships
Resource Translation Table (RTT)
Controlling the IMS attachment
IMS Subsystem Member (SSM)
Subsystem Member relationships
Resource Translation Table (RTT)
Controlling the IMS attachment
Distributed Data Facility
VTAM components
Enabling TCP/IP communication
Communications tables
Distributed security
Introduces the various attachment facilities and how they are set up and invoked

Security overview
Address space authorisation
Protected access profiles
Permitting RACF access
Protecting Db2 datasets
Security management (Db2 or RACF)
Security strategy (Transaction Manager or Db2)
Security management (centralised or decentralised)
Traditional Db2 security mechanism
Security terminology
Authorisation id
Maintaining security
Data Control Language
Administrative authorities
Additional administrative authorities
Explicit & implicit privileges
Ownership considerations
Level of access
Using VIEWs
Multi-Level Security overview
Security labels

Row level granularity
Multi-Level Security and SELECT
Multi-Level Security and INSERT
Multi-Level Security and UPDATE
Multi-Level Security and DELETE
Multi-Level Security and utilities
Row and column access
Row permissions
Column masks
Db2 security using RACF profiles
RACF / Db2External Security Module
Installation
Mapping Db2 authorisation checks
Scope of RACF classes
Multi-subsystem scope classes
Single subsystem scope classes
Customisation
Db2 objects and RACF classes
Profiles.
Covers the system security requirements and the SQL syntax to maintain Db2 security

Db2 Logging
Db2 log processing
Unit Of Recovery
Two-phase commit protocol
Active Log parameters

Checkpoint parameters
Checkpoint records
Logging commands - SET LOG
Logging commands - DISPLAY
Logging commands - ARCHIVE. Describes the Db2 logging strategy and the components involved

Backup & recovery components
Invoking online utilities using Db2i
Invoking utilities - dataset names
Invoking utilities - control statements
Controlling utilities using Db2i
COPY utility
COPYTOCOPY
MERGECOPY utility
QUIESCE utility
RECOVER utility

Point-In- Time recovery
REBUILD INDEX utility
REPORT utility
MODIFY utility
Other online utilities
Stand-alone utilities (service aids)
Catalog & directory recovery
Catalog & directory point in time recovery
P-I-T recovery implications.
Discusses the utilities available to backup and restore Db2 application and system data

Db2 command format
Starting Db2
Integrity - normal termination
Integrity - abnormal termination
Log Initialisation
Current Status Rebuild
Forward Log Recovery
Backward Log Recovery
Processing log records
In-doubt resolution
Deferred restart: effect on committed UORs, effect on in-flight UORs

Delaying backout of long running tasks
Effect of delaying backout
Conditional restart: Control Record, log Truncation / limit restart, bypass backout / cold start
Conditional restart implications
Maintaining data integrity with conditional restart
Stopping Db2
BACKUP SYSTEM utility
BACKUP SYSTEM control data
RESTORE SYSTEM utility
Restoring to a point in time.
Examines the utilities to backup and recover the entire system and discusses the normal and specialised Db2 start-up processes

Db2 commands
Controlling the Db2 subsystem
Controlling the IRLM
Controlling the TSO Attachment
Controlling the CICS Attachment
Controlling the IMS Attachment
Issuing commands using Db2 Interactive
Controlling Distributed Data Facility
Controlling logging
Controlling buffer pools
Controlling data sharing

Controlling utilities
Controlling Resource Limit Facility
Controlling databases
Controlling threads
Controlling procedures
Controlling functions
Db2 traces
Trace classes
Controlling traces.
Describes the Db2 traces available, and their use in basic system and application tuning, and general control of the Db2 system

Basic code structure
Db2 subcomponents
Db2 control block structure
Db2 page sets
Page set structure
Index structure
Index keys and pointers
Data navigation
RIDs, map ids, pointers and holes
Row headers
Row data format
Versions and system pages
OBDREC entries
Version examples

Identifying and handling problems
Basic dump analysis
Diagnosis tools: traces, utilities
Possible problem areas
Active log out of space
Active log I/O errors
Archive log I/O errors
BSDS errors
Forced single BSDS mode
Recovering BSDS
Data errors
Down level datasets.
Covers the Db2 messages and tools available to handle various problem scenarios

What is 'performance'?
Performance objectives
Workload categories
Service Level Agreements
Performance factors
System parameters
EDM pool size

Buffer pool sizes
Buffer pool thresholds
Buffer pool development
Database design factors
Application design factors
Db2 traces

Architecture overview
Working Storage Areas
Buffer, Sort, RID & EDM pools
Buffer Pools - 64 bit addressing
EDM pool
Sort pool
RID pool
Db2 Attachments
System data sets & databases
Db2 objects
Object characteristics
SQL overview
DB2 Interactive (DB2I)
Basic Db2 operations
Db2 commands
DB2I commands panel.
This segment examines the major components of the Db2 system

DASD storage requirements
Storage estimates (Db2 system)
Storage estimates (Db2 datasets)
DASD requirements - user data
DASD requirements - user indexes
Virtual storage requirements

Buffer, Sort & RID pool storage
EDM pool storage
DSCBs and working storage
Real storage estimation
Planning for data sharing.
This segment identifies the major tasks involved in planning for the installation and/or migration of a Db2 subsystem

Definitions
Db2 modes (Db2 11)
Db2 Function Levels (Db2 12)
Installation / Migration step
The major Installation / Migration tasks
Additional tasks and jobs
Loading Db2 libraries (the SMP/E process)
The installation CLIST
Invoking the installation CLIST
Updating the CLIST defaults (DSNTIJXZ)

DSNTIPA1 - Installation CLIST Main Panel
DSNTIP0A - data sharing options (Type INSTALL)
DSNTIP0B - data sharing options (Type MIGRATE)
Installation CLIST Panels (Db2 12 for z/OS)
Optional Installation Panels
DSNTIPC, DSNTIPC1 - CLIST calculations
The customised jobs
Jobs DSNTIJUx - Define parameters.
This segment describesand explains the major tasks involved in the installation and/or migration of a Db2 subsystem

Migration considerations
Pre-migration queries (DSNTIJPM)
Migration compatibility
Migration tasks
Prerequisites & maintenance level of current system
Integrity of current system
Back-up current system
Migration steps
Other migration tasks

Fallback
Enabling New Function Mode (ENFM) jobs
Activate (change Function Level) jobs
Updating Db2 - using the installation CLIST
Updating Db2 - modifying the generated job(s)
Invoking modified parameters
-SET SYSPARM command
This segment describe and explains the tasks involved in migration and modification of a Db2 subsystem

Db2 Attachments
Db2 connections (Attachments)
Universal Language Interface Module (DSNULI)
DSNULI entry points
TSO Attachment
Job DSNTIJVC - Build the CLIST library
Make libraries available to TSO
Connect DB2I panels to main panel
Invoking TSO Attachment
CICS Attachment
CICS / Db2 connection
Defining Db2CONN
Defining Db2ENTRY
Defining Db2TRAN
Controlling CICS Attachment

IMS Attachment
IMS Subsystem Member (SSM)
Subsystem Member relationships
Resource Translation Table (RTT)
Controlling the IMS attachment
IMS Subsystem Member (SSM)
Subsystem Member relationships
Resource Translation Table (RTT)
Controlling the IMS attachment
Distributed Data Facility
VTAM components
Enabling TCP/IP communication
Communications tables
Distributed security
Introduces the various attachment facilities and how they are set up and invoked

Security overview
Address space authorisation
Protected access profiles
Permitting RACF access
Protecting Db2 datasets
Security management (Db2 or RACF)
Security strategy (Transaction Manager or Db2)
Security management (centralised or decentralised)
Traditional Db2 security mechanism
Security terminology
Authorisation id
Maintaining security
Data Control Language
Administrative authorities
Additional administrative authorities
Explicit & implicit privileges
Ownership considerations
Level of access
Using VIEWs
Multi-Level Security overview
Security labels

Row level granularity
Multi-Level Security and SELECT
Multi-Level Security and INSERT
Multi-Level Security and UPDATE
Multi-Level Security and DELETE
Multi-Level Security and utilities
Row and column access
Row permissions
Column masks
Db2 security using RACF profiles
RACF / Db2External Security Module
Installation
Mapping Db2 authorisation checks
Scope of RACF classes
Multi-subsystem scope classes
Single subsystem scope classes
Customisation
Db2 objects and RACF classes
Profiles.
Covers the system security requirements and the SQL syntax to maintain Db2 security

Db2 Logging
Db2 log processing
Unit Of Recovery
Two-phase commit protocol
Active Log parameters

Checkpoint parameters
Checkpoint records
Logging commands - SET LOG
Logging commands - DISPLAY
Logging commands - ARCHIVE. Describes the Db2 logging strategy and the components involved

Backup & recovery components
Invoking online utilities using Db2i
Invoking utilities - dataset names
Invoking utilities - control statements
Controlling utilities using Db2i
COPY utility
COPYTOCOPY
MERGECOPY utility
QUIESCE utility
RECOVER utility

Point-In- Time recovery
REBUILD INDEX utility
REPORT utility
MODIFY utility
Other online utilities
Stand-alone utilities (service aids)
Catalog & directory recovery
Catalog & directory point in time recovery
P-I-T recovery implications.
Discusses the utilities available to backup and restore Db2 application and system data

Db2 command format
Starting Db2
Integrity - normal termination
Integrity - abnormal termination
Log Initialisation
Current Status Rebuild
Forward Log Recovery
Backward Log Recovery
Processing log records
In-doubt resolution
Deferred restart: effect on committed UORs, effect on in-flight UORs

Delaying backout of long running tasks
Effect of delaying backout
Conditional restart: Control Record, log Truncation / limit restart, bypass backout / cold start
Conditional restart implications
Maintaining data integrity with conditional restart
Stopping Db2
BACKUP SYSTEM utility
BACKUP SYSTEM control data
RESTORE SYSTEM utility
Restoring to a point in time.
Examines the utilities to backup and recover the entire system and discusses the normal and specialised Db2 start-up processes

Db2 commands
Controlling the Db2 subsystem
Controlling the IRLM
Controlling the TSO Attachment
Controlling the CICS Attachment
Controlling the IMS Attachment
Issuing commands using Db2 Interactive
Controlling Distributed Data Facility
Controlling logging
Controlling buffer pools
Controlling data sharing

Controlling utilities
Controlling Resource Limit Facility
Controlling databases
Controlling threads
Controlling procedures
Controlling functions
Db2 traces
Trace classes
Controlling traces.
Describes the Db2 traces available, and their use in basic system and application tuning, and general control of the Db2 system

Basic code structure
Db2 subcomponents
Db2 control block structure
Db2 page sets
Page set structure
Index structure
Index keys and pointers
Data navigation
RIDs, map ids, pointers and holes
Row headers
Row data format
Versions and system pages
OBDREC entries
Version examples

Identifying and handling problems
Basic dump analysis
Diagnosis tools: traces, utilities
Possible problem areas
Active log out of space
Active log I/O errors
Archive log I/O errors
BSDS errors
Forced single BSDS mode
Recovering BSDS
Data errors
Down level datasets.
Covers the Db2 messages and tools available to handle various problem scenarios

What is 'performance'?
Performance objectives
Workload categories
Service Level Agreements
Performance factors
System parameters
EDM pool size

Buffer pool sizes
Buffer pool thresholds
Buffer pool development
Database design factors
Application design factors
Db2 traces

Workflow Orchestration

Mainframe Simplification

Popular destinations

BMC Mainframe: Db2 for z/OS - Systems Administration

Major release:

Good for:

Course Delivery:

Course Modules

Db2 System Architecture

Db2 Installation and Migration Planning

Db2 System Installation & Migration Overview

Db2 System Migration & Modification

Connecting to Db2

Db2 Security Administration

Db2 Logging

Db2 Data Recovery

Db2 System Recovery

Db2 Monitoring & Control

Problem Determination

Performance Overview

Course Modules

Db2 System Architecture

Db2 Installation and Migration Planning

Db2 System Installation & Migration Overview

Db2 System Migration & Modification

Connecting to Db2

Db2 Security Administration

Db2 Logging

Db2 Data Recovery

Db2 System Recovery

Db2 Monitoring & Control

Problem Determination

Performance Overview

Let us know how we can help

Sales & Pricing

Help & Support

Popular destinations

BMC Mainframe: Db2 for z/OS - Systems Administration

Major release:

Good for:

Course Delivery:

Course Modules

Db2 System Architecture

Db2 Installation and Migration Planning

Db2 System Installation & Migration Overview

Db2 System Migration & Modification

Connecting to Db2

Db2 Security Administration

Db2 Logging

Db2 Data Recovery

Db2 System Recovery

Db2 Monitoring & Control

Problem Determination

Performance Overview

Course Modules

Db2 System Architecture

Db2 Installation and Migration Planning

Db2 System Installation & Migration Overview

Db2 System Migration & Modification

Connecting to Db2

Db2 Security Administration

Db2 Logging

Db2 Data Recovery

Db2 System Recovery

Db2 Monitoring & Control

Problem Determination

Performance Overview

Related Learning Paths