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

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