Optimum storage configuration for OLTP mode

Using DB2 UDB running on UNIX, how would I set up a storage configuration for optimum performance when in OLTP mode?

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top