Home > Ask the Data Storage Experts > Questions & Answers > Optimum storage configuration for OLTP mode
Ask The Storage UK Expert: Questions & Answers
EMAIL THIS

Optimum storage configuration for OLTP mode

Greg Schulz EXPERT RESPONSE FROM: Greg Schulz

Pose a Question
Other Storage UK Categories
Meet all Storage UK Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 15 December 2006
Using DB2 UDB running on UNIX, how would I set up a storage configuration for optimum performance when in OLTP mode?

>
EXPERT RESPONSE
Without knowing more about your applications performance characteristics and service requirements along with what type of storage you have, a specific recommendation would not be appropriate. However in general, look to spread your database files and objects including log files, journals, indices and tables across different volumes to avoid bottlenecks and contention.

For write intensive applications, RAID 0+1 is a good fit and for I/O or transaction intensive files and objects, solid state disk can be a good fit. If you have not already done so, check out the various IBM Redbooks and RedPapers pieces where you can find in-depth articles on configuring storage for DB2/UDB on UNIX for different types of storage.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
RAID
UK storage startup boosts US market presence
Regaining data from broken RAID-0+1array
Migrating data from four 400 GB SATA drives
RAID 6 vs. RAID 10
Creating half a mirror out of 3 drives totaling 300 GB
Top 5 SAN tips of 2007
Using global spare drives to increase SAN reliability
Growing a RAID group by adding old drives
Where is the best place and best technique for implementing RAID?
How to calculate available disk space on a RAID 5

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts