Q

Optimum storage configuration for OLTP mode

SAN expert Greg Schulz answers a reader's question: "How would I set up a storage configuration for optimum performance when in OLTP mode?"

Using DB2 UDB running on UNIX, how would I set up a storage configuration for optimum performance when in OLTP mode?
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.

This was first published in January 2007

Dig deeper on RAID

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchSolidStateStorage

SearchVirtualStorage

SearchCloudStorage

SearchDisasterRecovery

SearchDataBackup

Close