Articles & Content


FlashCopy in DB2 10 and Early Performance Expectations (G11)

Topic: 2011 NA

Subtopic: DB2 for z/OS

DATE: 2011-5-5 (01:30 PM - 02:30 PM)
SPEAKERS: Judy Ruby-Brown (IBM )

This presentation describes DB2 10 capability in the area of COPY and RECOVER utilities. Users with investment in FlashCopy technology can create data set level image copies under DB2 control. Reduced CPU and elapsed time is realized for larger table spaces or partitions. Benefits include the copying of multiple objects at the same point of consistency without an outage (for restoration to another DB2 system for various purposes), RECOVER can accept a flash copy image copy as input. RECOVER also has a separate option, BACKOUT YES, to recover objects by backing them out (think backing out 30 minutes versus restoring a 3-day old copy and applying log). The use of FlashCopy technology for those with mirrored DASD using Metro Mirror (PPRC), is also described.. Early performance results of some of these capabilities will be provided.

EXP. LEVEL: Intermediate


You will learn how FlashCopy image copy works, how it is different from traditional image copies produced by DB2? What consistent copies are and how they are created. Why you may want them.

How does recover with BACKOUT (YES) work? When should you use it versus forward recovery?

How System Level Backup (SLB) in DB2 10 and z/OS 1.11 provide more opportunity for data set level recovery.

Can you use the new DB2 10 FlashCopy capabilities if you have mirrored DASD (Metro Mirror PPRC)?

Recommendations for use of FlashCopy image copies

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.