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
Application Data Recovery for DB2 UDB for z/OS & OS/390
 
 
 
 
ibm certified training   this course works with savings passes
 
code. CF891   length. 3 days
type. Instructor-Led   partner. IBM
price.
$1,950  
 

IACET credits 2.4
 
Learn how data and index recovery is supported by DB2 UDB for z/OS and OS/390 in order to develop the knowledge and skills you need to design and implement backup and recovery procedures for your installations.

Practice using the utility functions and techniques included in the lecture material during extensive interactive machine lab exercises on an OS/390 system.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 
Individuals who support and implement application data backup and recovery procedures for DB2 UDB for z/OS and OS/390.
 
prerequisites
  
 
You should complete:

DB2 UDB for z/OS and OS/390 Database Administration Workshop (CF830) or equivalent


 
skills gained
  
 

Design and implement application data backup and recovery procedures for your installations


 
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
  
 

Intermediate


 
course content details  
 


  Backup and recovery basics

Describe the major situations requiring the recovery of data
Explain the basic DB2 logging concept
Explain the basic DB2 backup and recovery concept
Describe the restrictive and advisory states relevant for backup and recovery
Explain the purpose of the Logical Page List and of Write Error Page Ranges




  Normal backup of table and index spaces (normal backup in this context means the creation of DB2 image copies using the COPY utility)

Create full and incremental image copies or inline copies for table spaces
Create conditional image copies for table spaces
Create image copies for indexes
Establish additional copies of image copies
Merge full and incremental image copies to obtain new full or incremental image copies
Delete image copies no longer needed
Following the lecture, you will practice these COPY functions by completing a series of machine lab exercises




  Normal recovery of table and index spaces (normal recovery in this context means the recovery using DB2 image copies and the RECOVER utility)

Prepare the recovery of a table space or index space
Recover a table space or COPY enabled index space to current
- An entire table space or index space
- A partition or data set
- An error range
Replace defective volumes during recovery
Understand the fallback recovery concept
Rebuild indexes
You will perform online machine exercises to acquire skills necessary to:
- Recover a table space or a copy enabled index to current
- Replace a defective volume during recovery
- Recover a table space when local image copy data sets are not available
- Understand additional recovery considerations when dealing with Large Object (LOB) data




  Point-in-time recovery (normal recovery to an earlier point in time for table spaces and index spaces)

Plan for point-in-time recoveries
Prepare point-in-time recoveries
Perform point-in-time recoveries involving table spaces other than LOB table spaces
Perform point-in-time recoveries involving LOB table spaces
Understand the consequences for LOB table spaces with LOG NO
Resolve pending conditions resulting from point-in-time recoveries
Following this lecture, you will perform a set of exercises to acquire skills necessary to recover application data to an earlier point-in-time from image copies using the DB2 RECOVER utility




  Generic utility jobs (LISTDEF, TEMPLATE, and OPTIONS as far as they are relevant for backup and recovery)

Provide reusable list definitions for use by the DB2 utilities
Use list definitions in utility control statements and understand how they expand
Describe the concept and working of templates replacing utility DD statements
Use templates in utility jobs to simplify Job Control Language (JCL)
Use templates together with list definitions
Use the OPTIONS utility control statement to control execution parameters for utility jobs
You will perform online exercises to gain skills in:
- Creating reusable list definitions
- Using list definitions in utility control statements
- Creating templates for dynamic allocation of utility data sets
- Using templates in utility jobs to simplify JCL
- Using the OPTIONS control statement




  Using nonstandard copies (for the backup and recovery of table spaces or index spaces)

Establish DB2 Data Facility Storage Management Subsystem (DFSMS) concurrent copies using the CONCURRENT option of the COPY utility
Restore DB2 DFSMS concurrent copies established using the CONCURRENT option
Understand the prerequisites for establishing nonstandard copies
Establish and restore nonstandard copies using the DSN1COPY stand-alone utility
Establish and restore nonstandard copies using native DFSMS Data Set Services (DFSMSdss)
During the hands-on exercises for this topic you will:
- Create nonstandard copies using the DSN1COPY stand-alone utility
- Restore nonstandard copies using the DSN1COPY stand-alone utility
- Apply log changes to restored copies




  Special recovery situations (including down-level data, the recovery of dropped objects, and the repair of pages)

Handle down-level data
Prevent the accidental dropping of tables, table spaces, or databases
Recover accidentally dropped table spaces
Recover accidentally dropped tables
Print and analyze pages of table spaces or partitions
Repair pages of table spaces if necessary
The interactive exercises for this topic include practicing the techniques to:
- Recover an accidentally dropped table
- Recover an accidentally dropped table space
- Print and analyze pages of a table space
- Repair a pages of table space




  Application recovery (how application programs should be structured to preclude recovery problems and what can be done if they do not follow these recommendations)

Convince application programmers to structure programs into committable units
Teach application programmers how to make programs restartable
Advise system programmers in canceling threads without backout being performed
Instruct system programmers how to postpone backout work during DB2 restarts
Cancel the postponed backout for objects being recovered or replaced



 
Free Chumby with IBM Training

Save on IBM Training



find a course
 
phone us
 
view course schedule





Sun Microsystems Training Special

 
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