DB2 for z/OS and OS/390 Data Sharing Recovery and Restart

M/UX
Chicago, Phoenix, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.


Skills Taught

--------------------------------------------------------------------------------

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


Course outline

--------------------------------------------------------------------------------

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
Daily agenda

Day 1

Welcome
Data sharing overview
OS/390 and z/OS sysplex availability and recovery
Sysplex and data sharing commands
Database recovery environment
DB2 restart
Day 2

Sysplex failures: CPC and sysplex timer
Sysplex failures: SCA and DB2 Lock structure
Sysplex failures: group buffer pools
Data sharing non-sysplex failures
Disaster backup and recovery
Disabling and reenabling data sharing


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

...''

Phone:866-700-9811

School Address:

pSeries/AIX, CISCO, Linux, Microsoft, Professional Skills, Project Management, RedHat LINUX Enrollments 866-700-9811 (Toll Free) or 916-226-2537

CICS, iSeries/OS400, Enterprise/zSeries and WebSphere Enrollments 888-689-3326 (Toll Free) or 916-226-2511

DB2 UDB, Rational Software, and Tivoli Enrollments 866-700-9817 (Toll Free) or 916-226-2533

M/UX
9245 Laguna Springs Drive
Suite 315
Elk Grove, CA 95758 USA

Jobs & Resumes: Chicago, Phoenix
Houses & Roommates: Chicago, Phoenix

DB2 SQL Workshop
Relational Database Design
Using Rational Data Architect
DB2 9 Database Administration Workshop for Linux/UNIX/Windows
DB2 Universal Database Administration Workshop for Windows
DB2 Universal Database Administration Workshop for UNIX
DB2 UDB Multi Partition Database Administration Workshop for UNIX
DB2 9 for LUW Multiple Partition DBA Workshop
DB2 UDB for z/OS and OS/390 Data Sharing Implementation
DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
DB2 9 for LUW Advanced Database Recovery
DB2 Stored Procedures Programming Workshop
DB2 UDB Application Programming Workshop
DB2 UDB for z/OS System/Disaster Recovery Workshop
Query and Manage XML data with DB2 9
DB2 UDB for z/OS Stored Procedures using COBOL
DB2 and SQL Programming Workshop
iSeries RPG IV Version 5 Programming Fundamentals Workshop

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.