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.
Published on 03 May 2002
ISBN-10: 073842319X
ISBN-13: 9780738423197
IBM Form #: SG24-6286-00
Authors: Hernando Bedoya, Larry Youngren, Monti Abrahams, Yuhko Asaeda, Jon Mathews, Adam Stallman and Valentin Sueiro
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.
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