Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
DB2 UDB for z/OS and OS/390 Data Sharing Recovery/Restart Workshop
 
 
 
 
ibm certified training   this course works with savings passes
 
code. CF360   length. 4 days
type. Instructor-Led   partner. IBM
price.
$4,595  
 
Skill level: Advanced
 
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 a DB2 data sharing configuration overview. Check and prepare your data sharing environment. Examine 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.
 
course schedule  
 
Atlanta, GA dec.9.2008 - dec.12.2008 register register
Irving/Dallas, TX mar.9.2009 - mar.12.2009 register register
     
   
Request another training Date Request onsite training
 
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, and 7.
 
hands-on labs
  
 
Ten labs are included and expanded to twenty different types of recovery/restarts to address DB2 recovery of a DB2 data sharing subsystem environment. All aspects of coupling facility failures of DB2 structures are recovered and experienced in this complex Parallel Sysplex environment. A DB2 data sharing environment has already been established and is ready for you to use.

Lab teams of two or three people perform the recovery/restart steps of data sharing on their own parallel sysplex environment.
 
ibm education advantage program eligibility:
  
 

Yes - IBM Education Pack




 
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




  Lab: hands-on laboratory exercise topics:

exercise checking and preparing your data sharing environment
enable and test automatic restart of members




  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 the Bootstrap Data Set (BSDS)
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




  Lab: hands-on laboratory exercise topics:

exercise utilities in a data sharing environment
exercise retained locks from Data Manipulation Language (DML) statements
exercise retained locks from online utilities
exercise retained locks from Data Definition Language (DDL) statements




  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


  Lab: hands-on laboratory exercise topics:

exercise group restarts without quiesced members
exercise group restart with quiesced members
exercise group restart without BSDS for quiesced members




  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




  Lab: hands-on laboratory exercise topics:

exercise rebuilding SCA and DB2 lock structure
exercise 100% loss of SCA and DB2 lock structure
exercise failure to rebuild SCA and 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




  Lab: hands-on laboratory exercise topics:

exercise rebuilding group buffer pools
exercise automatic recovery of page sets
exercise no automatic recovery of page sets
exercise deallocating and reallocating group buffer pools
exercise resolving LPL conditions if group buffer pool not rebuilt




  Data sharing non-sysplex failures

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




  Lab: hands-on laboratory exercise topics:

exercise moving page sets or partitions to different group buffer pools




  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




  Lab: hands-on laboratory exercise topics:

exercise archive log mode (quiesce)
exercise archive log scope (group)




  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





 
Free Chumby with IBM Training

Save on IBM Training



find a course
 
phone us
 
view course schedule





Advanced training to the point. Contact an expert training consultant to put together the best training package for your organization

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware