DB2 for OS/390 Data Sharing Recovery and Restart

start > courses and registration > training feature sheet

code.

CF320

length.

2 days

type.

Instructor-Led

partner.

IBM

price.

$1,300

IACET credits 1.6

Learn to plan and implement recovery procedures for a DB2 UDB for z/OS and OS/390, Version 7 Data Sharing installation. Expand all local recovery and disaster recovery procedures to support a DB2 data sharing environment. Get an overview of DB2 data sharing configuration and learn about checking and preparing your data sharing environment, automatic restart of members, test data sharing functions and utilities, retain locks, group restarts, rebuilding Shared Communications Area (SCA), Coupling Facility DB2 Lock Structure (LOCK1), and group buffer pool structures, automatic recovery of page sets, resolving Logical Page List (LPL) conditions, and recovery using archive log commands.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is an advanced course for senior system administrators, senior database administrators, and senior technical system professional individuals, who plan, implement, recover, and maintain DB2 UDB for z/OS and OS/390.

prerequisites

You should complete:

	DB2 UDB for z/OS and OS/390 System Administration (CF850)
	DB2 UDB for OS/390 System/Disaster Recovery Workshop (CF910)
	DB2 UDB for z/OS and OS/390 Data Sharing Implementation (CF311)
	OR DB2 UDB for OS/390 Data Sharing Implementation Workshop (CF350)
	OR have working knowledge of OS/390 sysplex, DB2 data sharing, and DB2 recovery

skills gained

	Implement sysplex component recovery procedures
	Use database recovery procedures
	Implement subsystem recovery procedures
	Use coupling facility recovery procedures
	Implement disaster recovery procedures

course materials

The course materials cover DB2 UDB for z/OS and OS/390 data sharing with topics pertaining to multiple DB2 versions from DB2 Version 4, 5, 6, 7.

training path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

ibm education advantage program eligibility:

	Yes - IBM Education Card
	Yes - IBM Education Pack
	Yes - IBM Corporate Education Pass
	Yes - IBM Education Pack - online account

skill level

Advanced

course content details

	DB2 data sharing overview

	describe the major components of DB2 data sharing
	list the hardware requirements for DB2 data sharing
	describe the DB2 mechanisms for providing global data integrity
	describe the DB2 mechanisms for providing global consistency
	describe the recovery implications of data sharing

	OS/390 sysplex availability and recovery

	determine the availability implications of hardware and software configurations of a System/390 Parallel Sysplex
	name the hardware and software components that can influence sysplex recovery
	configure these components to achieve the desired recovery actions
	list the Coupling Facility Resource Manager (CFRM), Sysplex Failure Manager (SFM), and Automatic Restart Manager (ARM) policy parameters that are essential for recovery and restart

	Sysplex and data sharing commands

	determine the active policies of a sysplex
	display details about the coupling facilities and structures of a sysplex
	display detailed information about data sharing groups and their members
	display detailed information for group buffer pools

	Database recovery environment

	list the changes that have been implemented in DB2 to support database recovery in a data sharing environment
	describe how these changes affect catalog and directory tables
	describe how these changes affect the log
	describe how these changes affect utilities
	perform a database recovery in a data sharing environment

	DB2 restart

	describe the phases of a normal DB2 restart in a data sharing environment
	point out the changes for a normal DB2 restart as a consequence of data sharing
	describe what group restart is and when it is performed
	describe the phases of a group restart
	summarize the implications of data sharing on DB2 conditional restarts

	Sysplex failures: Central Processing Complex (CPC) and sysplex timer

	identify CPC and sysplex timer failures
	describe the system actions performed for CPC and sysplex timer failures
	recover from CPC and sysplex timer failures

	Sysplex failures: SCA and DB2 lock structure

	identify sysplex failures for the SCA or the DB2 lock structure
	describe the system actions performed for sysplex failures for the SCA or the DB2 lock structure
	recover from sysplex failures for the SCA or the DB2 lock structure

	Sysplex failures: group buffer pools

	identify sysplex failures for group buffer pools
	describe the system actions performed for sysplex failures for group buffer pools
	recover from sysplex failures for group buffer pools

	Data sharing non-sysplex failures

	identify non-sysplex failures
	describe the system actions performed for non-sysplex failures
	recover from non-sysplex failures

	Data sharing disaster backup and recovery

	describe different methods of disaster backup and recovery
	describe how the data sharing group must be configured at the recovery site
	perform the preparatory backup for a disaster recovery at the local site
	describe the steps involved in a disaster recovery
	point out the differences for the disaster recovery procedure for data sharing
	prepare and test a disaster recovery for a data sharing group at the recovery site, if you already performed a disaster recovery for a single DB2 subsystem

	Disabling and reenabling data sharing

	describe the consequences of disabling data sharing
	describe data sharing in a test environment
	reenable data sharing after you have disabled it