Striving for Optimal Journal Performance on DB2 Universal Database for iSeries

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on May 03, 2002

  1. .PDF (3.1 MB)


Share this page:   

ISBN-10: 073842319X
ISBN-13: 9780738423197
IBM Form #: SG24-6286-00


Authors: Hernando Bedoya and Larry Youngren Monti Abrahams Yuhko Asaeda Jon Mathews Adam Stallman Valentin Sueiro

    menu icon

    Abstract

    Journaling is an inherent feature of OS/400 on the iSeries that has been around since the early releases of the System/38. The system employs journals to ensure data integrity and recoverability and this support can further be extended to reduce the duration of an abnormal system end. Journaling also serves as the cornerstone upon which many data replication and data warehouse refresh schemes are built.

    The aim of this IBM Redbooks publication is to provide you with an understanding of the factors which influence journal performance on the iSeries and to help you identify which hardware options and software settings you can employ to minimize this impact. We will also share with you some ideas on how to minimize the impact of journaling on your iSeries from an application point of view.

    We also explain the remote journal function on the OS/400, which offers a reliable and fast method to transfer journal entries to a remote iSeries server. We performed tests concerning remote journal performance and tested this function in different environments.

    Table of Contents

    Chapter 1. An introduction to journaling performance

    Chapter 2. The testing environment

    Chapter 3. Hardware choices

    Chapter 4. Journaling tuning

    Chapter 5. Application and software environment tuning

    Chapter 6. Remote journaling performance

    Chapter 7. Conclusion

    Appendix A. How to calculate the fast write percentage

     

    Others who read this also read