Articles & Content


Space: The Storage Frontier for Distributed DB2 DBA's (A12)

Topic: 2007 NA

Subtopic: DB2 for LUW

DATE: 2007-5-10 (09:20 AM - 10:20 AM)
SPEAKERS: Jerry Spence (National City Corporation)

All Databases reside on storage. Most storage is nothing but boxes of hardware to most people, but the DBA most go beyond the basic and understand how storage is laid out and the components of the storage design and how it relates to the database. This presentation will present storage concepts and how they relate to the database and some considerations for deploying a database on the various storage devices.

EXP. LEVEL: Beginner,Intermediate


The Hardware Side of storage. Controllers, storage arrays, HBA's, and the server. Putting the pieces together. Different types of Raids will be discussed

Aix View of Storage. Logical volume manager and how the hardware is seen by the OS

The database view of storage. How storage layouts affect tablespaces, tables and peformance

Understand how multi-partitioned databases require special considerations when designing the storage layout and some special considerations

How backup and recover strategies can impact storage useage. DRP presents storage considerations

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.