Articles & Content
Archives
LOAD REPLACE 25 Million Rows in 2 Seconds (A07)
Topic: 2005 NA
Subtopic: DB2 for z/OS
DATE: 2005-05-24 (12:30 PM - 01:40 PM)
SPEAKERS: Mike Walsh (SunTrust Bank)
Do you have an application that performs LOAD REPLACE daily? Would you like to reduce the unavailability of that data during LOAD to nearly zero? This presentation describes a creative technique used at SunTrust Bank to trim the "down time" for LOAD REPLACE on critical tables to a few seconds. The good news is that you already have all the tools you need.
EXP. LEVEL: Intermediate,Advanced
OBJECTIVES:
The unavailability problem?
Fast Loading Utilities fall short.
The LOAD Process
The Transformation
The SWITCH
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!
Download File
Click to Download
Download File
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.