Skip to main content

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 03 May 2002

  1. .PDF (3.1 MB)

 Order hardcopy
Share this page:   

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

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